Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Have my Excel dates been damaged if they turn into five-digit numbers?

Technology category photographTechnology

My helper changed a range in our booking sheet to General format. The date cells now show five-digit numbers. She wants to type all the dates back in from the printed list, but we haven't changed the entries themselves.

Microsoft describes Date as a way to display date-and-time serial numbers and says number formatting changes the display rather than the stored value. Excel's number-format guidance

Should we try restoring a date format before re-entering anything? I have the earlier booking list to compare against, and I'd rather understand this change than introduce a new typing mistake while repairing a display problem.

Discussion

5 community replies

Yes, for the cells that held dates before the format change, apply an appropriate Date format and compare the result with your earlier list. The serial-number display fits Microsoft's explanation; it doesn't by itself show that the entries were corrupted.

Don't apply a date format to every five-digit number in the workbook. The booking sheet may contain actual quantities or identifiers too. Select by the meaning and known location of the date cells, not merely their appearance.

The helper's retyping plan is understandable if the numbers look like damaged data. Explain the difference between the stored entry and its display before anyone starts replacing values. A smaller repair could preserve what was already correct.

Start with a date you can independently identify on the earlier list, then inspect the rest of the affected range. A plausible-looking calendar date is not enough if it belongs to the wrong booking.

If one entry still disagrees, investigate that entry separately rather than assume the format change explains everything. Restoring the display can answer this particular mistake without certifying that the whole booking list was accurate beforehand.

Join the discussion

More in Technology