Date format

  • Thread starter Thread starter Steve
  • Start date Start date
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?
 
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.
 
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.
 
Someone told me.
Tools/options/(under window options)un-check formulas
 
Thanks some had just told me. But I didn't know how I did
it. Thanks again.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I stop Excel from copying date format from cell above? 2
Conditional formatting in Excel 2010 2
Remove date format? 3
Cell Formatting 2
Date Format Not Responding to MM/DD/YY 2
Columns formatted As Dates Are Exported as a Number to Text 1
date formatting broken in XL2003 SP3? 5
formatting of date 4

Back
Top