Hello,
I try many way to convert text into date but it doesn't work. Can any help me on this.
Example: 2015-07-20 ( text) this is lock even I go to text to column to change it still not work.
I want to convert it as 20 Jul 2015
Thanks,
Leakhna
Hello,
I try many way to convert text into date but it doesn't work. Can any help me on this.
Example: 2015-07-20 ( text) this is lock even I go to text to column to change it still not work.
I want to convert it as 20 Jul 2015
Thanks,
Leakhna
A formula can't change the ORIGINAL cell, but it can give you the correct result in an adjacent cell.
If the text string were in A1, then this formula in B1 would convert it to a date:
=DATEVALUE(A1)
...format B1 as Date format d mmm yyyy
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Love it much :D
Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks