Back in June, I asked (under the heading "CELL FORMATTING WILL NOT WOK") how
to resolve a problem I was having applying date formats in Excel 2000. A
lot of people offered help, and I spent many hours applying the various
solutions offered, all to no avail.

The problem is that, whether in an existing file or a new file, dates
entered in the form d/m/yy (or just about any other date representation)
cannot be formatted as dates and therefore cannot be used in formulae. My
preferred format is the Custom d/m/yy_), but I've tried many other date
formats, and none of them work, whether the format is applied before or
after the data are entered.

I was using Vista Home Premium with Excel 2000. I have a home network, and
the other 2 computers have Excel 2000 running under Windows XP. There is no
problem with date formats on either of those computers, INCLUDING when I
open Excel files on the Vista computer (ie, a file where the problem existed
on the Vista computer) using Excel 2000 on a Win XP computer.

I became convinced that there was some sort of conflict between Vista and
Excel 2000, so I upgraded to Excel 2003. But the problem still exists.
Don't laugh -- it is seriously bugging me, and I'm wasting a hell of a lot
of time trying to fix the problem.

Does anyone have any bright ideas? -- please!!!!!!!!!!!!!!!!!!!!!!

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