Thread: Cells will not clear - if I type 1 it comes up as 100 know matter
View Single Post
  #2  
Old April 13th, 2009, 05:30 PM posted to microsoft.public.excel.worksheet.functions
Niek Otten
external usenet poster
  
Posts: 2,533
Default Cells will not clear - if I type 1 it comes up as 100 know matter
ToolsOptionsEdit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"musicgirl" wrote in message
...
I have tried everything to clear out the cells. Nothing is working. When
I
do right click -- Format Cells -- Number -- Data it says that it is
"General" and the sample says "100". I have no idea how to change the
sample
if that is what is required.