Cheers :D
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 5:41 PM, aps wrote:
> data text to column works thanks !! :D
>
> On Mon, Dec 29, 2014 at 3:47 PM, Vaibhav Joshi wrote:
>
>> Hi Aps
>>
>> Check this...in case you want to keep date
data text to column works thanks !! :D
On Mon, Dec 29, 2014 at 3:47 PM, Vaibhav Joshi wrote:
> Hi Aps
>
> Check this...in case you want to keep date in dd.mm. format..
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Dec 29, 2014
Hi Aps
Check this...in case you want to keep date in dd.mm. format..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 2:16 PM, aps wrote:
> Hi,
>
> I had tried the same formula as you but it have a #VALUE! error. I have
> tried to
Hi
select column and use data text to column...
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 2:30 PM, aps wrote:
> When i checked the Evaluation steps i found out that excel is treating
> this date as a constant. How to convert it to a da
When i checked the Evaluation steps i found out that excel is treating this
date as a constant. How to convert it to a date. Format cells as date is
not working
On Mon, Dec 29, 2014 at 2:16 PM, aps wrote:
> Hi,
>
> I had tried the same formula as you but it have a #VALUE! error. I have
> tried t
Hi,
I had tried the same formula as you but it have a #VALUE! error. I have
tried to format the cells as date but no effect takes place when i do that.
Please see. ive added the column in the workbook u shared.
On Tue, Dec 23, 2014 at 6:18 PM, Ashish Kumar
wrote:
> Superb Solution Vaibhav Bhai.
Superb Solution Vaibhav Bhai.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
Check this..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 23, 2014 at 4:46 PM, Aparna wrote:
> hi,
>
> i have a column of around 150 different dates. i need to create a column
> where the year of all the dates is same but the month and day are
hi,
i have a column of around 150 different dates. i need to create a column
where the year of all the dates is same but the month and day are from the
corresponding cell in the original dates column
eg.
Original Col
08.06.1957 06.05.1963 02.10.1964 20.12.1957
New Col
08.06.2014 06.05
