Leave Zero's in cell

[Ivan B]

Hi,
when I put three zero's into a cell,.excel automatically changes it back to
one zero. I want to keep the three zero's in the cell. Woiuld appreciate
any advice please
Regards
Ivan

 

[RichardSchollar]

Hi Ivan

Either:

Format the cell as Text (although then the numbers entered are text
rather than genuine numerics) or format the cells to show leading
zeroes (eg a custom format like 000) - note that this is simply for
display purposes as the actual contents of the cell will be 0.

Hope this helps1

Richard