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 format.
- If I open the same file in Google Sheets, it correctly recognizes and formats the dates.
- Strangely, when I download the file from Google Sheets and reopen it in Excel, the dates display correctly in Excel.
Why is this happening, and how can I ensure Excel consistently interprets these values as dates? Any tips for resolving this issue would be greatly appreciated at code level ( Ruby on Rails ).
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?
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?
