Date formatting problem

Solved/Closed
Kiwi - 3 May 2010 à 20:42
 Kiwi - 3 May 2010 à 21:10
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 May 2010 à 21:02
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 (")

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