why does excel add 0's to a cell?

K

Kathryn

when I add numbers to a cell, excel adds tree zero's to the number. Is this a
bug in excel? How can I fix this problem?
 
C

Chip Pearson

Check the number format for the cell. Format it as General.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
S

Sandy Mann

Kathryn,

If Chip's suggestion does not cure your problem and the zeros are after the
number then try

Tools > Options > Edit and uncheck fixed Decimal Places

HTH

Sandy
 
Top