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
