Have my Excel dates been damaged if they turn into five-digit numbers?
TechnologyMy 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.