Excel - Converting Text to Date format

[rossmcl]

I have a date in excel in 9/24/2001 format. I think it is text as it appears on the left in the cell.

How do I convert it to date format - ie 24 October 2001


Thanks
rossmcl

 

[jebry]

Hi!

Right click in the cell and choose Formating Cells. Click on the Numbers tab and then choose custom from the list box. In the text box type dd mmmm yyyy.

I think that should do it.

hth
Jeff Bridgham

 

[ETID]

One way,...

Insert a column to the right of the "text date" data that you now have, let's say A1 is the first text date cell, then type in b1 =datevalue(a1) and fill down, then highlite column B and format custom as such "dd mmmm yy" (without the quotes)

then highlite column B and copy, then select cell B1 then "paste special" and select "values" then OK

then delete column A

 

[Sopman]

Go to Format - Cell. Under Category, select Custom.
Under "TYPE:"
Type this: d mmmm yyyy

 

[rossmcl]

Thanks for all your quick response...but.....

The custom formats doesnt change anything and using DATEVALUE brings up a #VALUE error in the cell. Does this mean it isnt a Text value?

I am confused - as if it isnt a text I thought custom format would have worked.

Thanks
rossmcl

 

[linmar]

rossmcl
If you format an empty cell with the custom format that you wish to use and then type in the date, it will appear in the correct format.
linmar