Desktop

Ask something
Discussion Locked

excel 97 cell format date shows #

0 helpful
2 replies

by vsawant

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to enter number in the cell and format it as date for fast entering data. When I do fromat cell, it shows ##### in date function. I increased the column width but no effect. Is there any way to do that.

2 replies

by mefcs

Have you tried double clicking on the border between the column headers to automatically size the column, and hence see if there is an error message?
Other likely causes are: invalid date-number (must be less than 32767 when entered as all dates are calculated relative to a date in 1904 if I recall correctly - I don't have Excel installed on this PC).
Field format may be invalid - was it one of the standard ones, or custom?

Otherwise, now you have formatted the cell as a date, you could try re-entering. E.g. if the format you chose was Dd/Mm/YY then entering 01/06 should return 01/06/2004.

If this does not resolve, what version of Excel/Windows are you using?
Regards,
Mary

This discussion is closed to new replies.