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
> 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