Date format

S

Steve

I did something in a spreadsheet where now anywhere I
enter a date I get a 5 digit number instead of the date.
If I click on the number, I can see the date in the edit
window. When I try to format the cell it doesn't change.
Can anyone tell me how to undue it?
 
D

Dave Peterson

Try tools|options|view tab and uncheck formulas.

You may have hit the shortcut key toggle (ctrl-`)

control-backquote. It's to the left of the 1/! on my USA keyboard.
 
C

carter

Go to format cell, seldect date, then select the type (format) you want the
date in. It is currently returning a number that represents the date.
 
Top