One possibility is that the "date" isn't a date recognized by Excel. Could be
just text. Perhaps you could paste some examples here in reply (copy the
values direct from the formula bar)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"geordy67" wrote:
I'm having trouble formatting dates in a office basic edition.
I'm going about it how I normally would, eg.
R click, format cells, date then selecting the one required, but it has
no effect.
I found the spreadsheet locked in protection so I unlocked it but this
didn't help.