Date formatting problem

Solved/Closed
Kiwi - May 3, 2010 at 08:42 PM
 Kiwi - May 3, 2010 at 09:10 PM
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?

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
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 (")

'
0
Thanks very much, you have solved quite a mystery. Appreciate your help. Cheers Kiwi
0