Try formatting the cell as a date, but then reenter the date.

Changing the format of a cell won't change the value in that cell. And I'm
guessing that the value in that cell is really text--not really a date.



Lindsay Graham wrote:

I'm using Excel 2000 on a Vista desktop and on an XP laptop. I'm finding
that cell formatting will not work any more. For example, if I try to apply
date or custom date formatting to a cell containing '8/6/08', the cell is
not formatted as a date. The only possible thing that I can think of is
that I was trialling OpenOffice and initially I thought that the problem was
limited to Excel files that I had opened in OpenOffice. But I'm now finding
that the problem exists in new files created in Excel that have never been
opened in OpenOffice.

Can anyone help? I've never had this problem before.

--
Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the newsgroup so that all may benefit.

--

Dave Peterson