Display problems...
BWGames wrote:
Hi,
This is perplexing me - I've got a sheet that when I set a cell to a
display format of..say Date, and enter 30/12/2003 (UK format), it displays
ok in the formula bar, as the date, but in the cell it becomes 37985. I
thought it could be set to Number format, as opposed to Date, but it
definitely is set to Date.
If you format 30-Dec-2003 as number, the result is 37985
How are you checking that the cell is formatted as Date?
Have you tried formatting it as Date "again" ?
--
Steve Garman
|