Date format problems

J

johnb

I've load a Excel W'book which contains dates in the
dd/mmm/yy format. Excel refuses to change the format when
I select dd-mmm-yyyy. At the Format/Cells/Date d'box the
Date and Customise are out of context. Any suggestions?

TIA johnb
 
N

Norman Harker

Hi Johnb!

Check to see if your dates are dates and not text.

Use: =ISTEXT(A1)

If text, then they won't react to your change of format.

If they are text, then:

Select an empty cell > Copy
Select the "dates"
Edit > Paste Special > Add > OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
G

Guest

Hi Norman
No luck. The ISTEXT function returns FALSE.
If I format the date cell to a general number and reformat
it to dd-mmm-yyyy it works. It will not reformat from
dd/mmm/yyy to dd-mmm-yyyy which it should do.

Regards
John Bell
 
N

Norman Harker

Hi John!

I'm baffled!

You can send it to me and I'll take a look but no promises!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top