Forum Discussion
Excel Displays Dates as Serial Numbers on Referring to a Cell, but Google Sheets Handles It
I’m encountering an issue with date formatting between Excel and Google Sheets: When referring to a cell with a date in Excel, it displays as sequential serial numbers instead of the expected date ...
Have you tried formatting the cells that show serial numbers as a date?
Hi HansVogelaar,
Yes, I’ve tried formatting the cell, and it works. However, is there a way to make it display the normal date format directly instead of the 1900 serial date system, without applying cell formatting manually?
I'm sorry, I don't know what causes this.
Hi HansVogelaar,
Yes, I’ve tried formatting the cell, and it works. However, is there a way to make it display the normal date format directly instead of the 1900 serial date system, without applying cell formatting manually?
