General discussion

Locked

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.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

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

See if this link helps:
www.cpearson.com/excel/DateTimeEntry.htm

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?
Regards,
Mary

Back to Desktop Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums