Problem formatting date
Solved/Closed
Hello,
I'm trying to use "date" to format cells in Excel 2003. I've selected number>date>mm/dd/yy. So, for example I enter today's date as 052010, instead of 05/20/10, it is converted to 05/24/42. Could someone please help?
I'm trying to use "date" to format cells in Excel 2003. I've selected number>date>mm/dd/yy. So, for example I enter today's date as 052010, instead of 05/20/10, it is converted to 05/24/42. Could someone please help?
Related:
- Problem formatting date
- Excel date format dd.mm.yyyy - Guide
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Whatsapp date format - Guide
- Formatting usb mac - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 20, 2010 at 03:52 PM
May 20, 2010 at 03:52 PM
The reason is in excel dates internally are serial number and this number equates to that that.
May 20, 2010 at 04:18 PM
May 20, 2010 at 04:24 PM
If this is a data dump and you want some column to be formatted as date, then see this
https://ccm.net/forum/affich-350882-cannot-change-the-date-format-in-excel-2007
May 20, 2010 at 04:32 PM
May 20, 2010 at 04:40 PM
May 20, 2010 at 04:45 PM