Solved excel 2010 date format problem

July 18, 2011 at 07:01:41
Specs: Windows XP
I have an excel spreadsheet with a date column. The column format is *3/14/2001. I enter 08/01/2011. The formula bar reads 8/1/2011. The cell reads 40756. If I put the cursor in the formula bar the cell reads 8/1/2011. Place the cursor any place else cell revers to 40756.

How can I get the date to display as a date in the cell.

See More: excel 2010 date format problem

Report •

July 18, 2011 at 12:12:25
✔ Best Answer
One of your options is messed up:

Click on the Office Button in the upper left corner
Click on Excel Options, down the bottom of pop up
Click on Advanced
Scroll down to the section that reads: Display Options for this Worksheet:
UN-Check the box that read: Show Formulas instead of their calculated results.
Click OK

That should correct your problem.


Report •

July 18, 2011 at 12:36:40
Thanks that was it.

Report •

Related Solutions

Ask Question