How Do I Convert Date:
10/3/2008 into October
6/1/2008 into June
7/3/2008 into July
etc.
I have date 10/3/2008 in cell and if I convert format to M into Just gives me first letter of Month, so O, I want it to read October, etc.
Thanks
How Do I Convert Date:
10/3/2008 into October
6/1/2008 into June
7/3/2008 into July
etc.
I have date 10/3/2008 in cell and if I convert format to M into Just gives me first letter of Month, so O, I want it to read October, etc.
Thanks
Last edited by VegasL; 01-20-2009 at 05:27 PM.
Select the range..
Right Click..
Select Format
select Number Tab..
Select Custom ( last option on the left hand side)
In box below Type: enter ---- mmmm
Shijesh Kumar
http://shijesh.wordpress.com/
Thanks Shijesh..worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks