General discussion


excel 97 cell format date shows #

By vsawant ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by mefcs In reply to excel 97 cell format date ...

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?

Related Discussions

Related Forums