Leave Zero's in cell

I

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting numbers with leading and trailing zero's 7
keeping leading 0's when formatting cells 3
convert Boolean true-false to zero's and ones 8
Omitting Zero's in Formula's 3
Preceeding zero in a UPC 8
AS400 Leading Zero's 3
Adding zero's to the beginning of a number 5
Numbers turning to Zero's 1

Top