Dates Changed to Numeric values

**drdr01** · 11-14-2012, 06:08 AM

I have a spreadsheet that has two sheets in the workbook. Both contain dates in the format dd/mm/yyyy. I have been using this workbook for years. It is in xls format.

Today on opening the second sheet I found the layout (col widths etc) had all changed. More importantly all the dates had changed into numeric values. If I point to a cell, it tells me that it is in date format , and above shows the date in the correct format, but the cell remains a numeric. The other problem is all the cells containing a sum calculation show the formula rather than the result.

All the dates and calculations on the first sheet are correct.

What have I done wrong?

**TMS** · 11-14-2012, 06:43 AM

The sheet is set to display formulas rather than calculated values.

You must have inadvertently pressed Ctrl-` ... I have no idea what that character is called but it's the top left of the keyboard, to the left of the 1/! key, above the tab key and below the Escape key ... so that should narrow it down.

Press Ctrl and ` (together) again and it will toggle the format back to what you normally see.

Regards, TMS

**drdr01** · 11-14-2012, 06:58 AM

Brilliant TMS, you cannot imagine what a relief that is!
Regards
DR

**TMS** · 11-14-2012, 07:13 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save