Cell formatting changed

  • Thread starter Thread starter Dave Kolars
  • Start date Start date
D

Dave Kolars

I have a workbook with 8 sheets in it... for some unknown reason, 1 of the
sheets has lost all the formatting of the cells; i.e., the column that was
dates now displays 37883 in the first cell, but the bar at the top shows
9/19/2003. The columns that used to be currency now show only numbers (40.9
instead of $40.90). I'm totaling cells across a row, and instead of the
dollar total I'm now seeing =SUM(D4:F4).

Have no idea what would have caused this... happened as if by black magic!
All the other sheets in the workbook are fine. There are no links in this
sheet to any other sheet. AND, I cannot reformat any of the cells.
Sheet/workbook is not protected.

I found that I could copy the offending worksheet and paste it into a new
sheet and the new sheet displays correctly!

Anybody experienced this before? Know the reason this happens? Very
frustrating! TIA DK
 
Hit CTRL+` to show values instead of formulas

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Tools|options|view Tab
Uncheck Formulas

This can be toggled by hitting ctrl-` (control-backquote, to the left of the 1/!
 
Thank you Dave & Niek!
I must have hit that key combination somehow? Been using Excel for years
and never knew about that toggle!
All is back to "normal"! Thanks again for the fast response. DK
 
Back
Top