Cell Format - Date Problems

  • Thread starter Thread starter Curtis Hansen
  • Start date Start date
C

Curtis Hansen

I have a spreadsheet with cells that I'm trying to type
the date into. I type in the date exactly like this:
09/26/03. When I hit "enter" MS Excel displays "37890"
in the cell. No matter what I do I can't the cell to
show: 09/26/03. I think that somehow I need to "strip"
the cell of what it's original format is, but I can't
figure out how. I try to use the Date option in the
format cell screen but it doesn't work.

Curtis
 
I tried this and it didn't work. I also tried the "Text
to columns" feature. No success.
 
You may have Formulas set to visible. To change this setting,

1. Choose Tools>Options
2. Select the View tab
3. Under Window options, remove the check mark from Formulas
4. Click OK

The keyboard shortcut is Ctrl + ` (accent grave, left of the 1 key)
 
That worked!! Thank you, thank you, thank you!!!! It
was driving me insane!!!!

You're a lifesaver!
 
Back
Top