Date formatting problem
Solved/Closed
I have a date in a cell that is 23/10/2008, and shows up as this in the editing bar, but in the cell address it shows a figure, ie 39744. Why is this and how can I change it to show the date?
Related:
- Date formatting problem
- 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 3, 2010 at 09:02 PM
May 3, 2010 at 09:02 PM
Press
CTRL + ` at same time. Right now it is showing you the formula (in a way)
For some reason ` is not coming out correctly. It is the symbol below ~ and not the single quote (') that is below double quote (")
'
CTRL + ` at same time. Right now it is showing you the formula (in a way)
For some reason ` is not coming out correctly. It is the symbol below ~ and not the single quote (') that is below double quote (")
'
May 3, 2010 at 09:10 PM