When a Cell Shows a Number Instead of a Date
Key points
- Enter the number
- See the date
- Fix the format
You can turn the number into a date with Excel Serial Date to see what it means.
Steps
- Enter the number
- See the date
- Fix the format
Setting the cell format to date shows it as a date in Excel too.
Use "Excel Serial Number and Date Converter" (free)
Tools that go well with this
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.
- UNIX Timestamp Converter: Convert between UNIX time and dates.
- Convert Between Western Years and Japanese Eras: Convert between AD years and Japanese eras.