Zero suppression.

V

Vicky

My intention is to retain the leading zeros of a number while entering the same in a cell. For Ex: 0010000 gets converted to 100000. i dont want this to happen. Any suggestions?
 
A

Arvi Laanemets

Hi

Format the cell as Custom "0000000" (the number of zeros determines to which
length are leading zeros added).

Or enter your numbers as text (you can't use them in calculations then
without converting them before). To enter numbers as text:
format the range/column as text;
or
preceed your entry with apostrophe, p.e. '0010000


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)



Vicky said:
My intention is to retain the leading zeros of a number while entering the
Click to expand...
same in a cell. For Ex: 0010000 gets converted to 100000. i dont want this
to happen. Any suggestions?
 
S

Steven M (remove cola to reply)

My intention is to retain the leading zeros of a number while
entering the same in a cell. For Ex: 0010000 gets converted
to 100000. i dont want this to happen. Any suggestions?
Click to expand...

If you know how many places you want to keep, try using a Custom
format string. Click Format / Cells, Number tab, Category = Custom.

Use one 0 (zero) in the "Type" window for each place.

Or format the cell as "Text"
 
Top