Date format problems

  • Thread starter Thread starter johnb
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top