Formatting Dates in a sheet imported from ACCESS

[Orlando Omizzolo]

I have imported a report from ACCESS 97 into EXCEL 97 and this worked fine.
However, when I tried to format the dates in EXCEL, nothing happens. I can
format other cells, just the existing date cells won't change unless I
retype the information. Seems almost like the format is locked??

Please advise how I can format these cells.

Thank You,


Orlando

 

[Debra Dalgleish]

The dates are being treated as text. There are some techniques here:

http://www.contextures.com/xlDataEntry03.html

that you could try, on a copy of your workbook, to convert the text
dates to real dates.