who I can write 0(Zero) in Excel?

[Jamil A.]

Hi
I want to know who I can write 0123 Digit in Excel 2002
Xp. Because wine I write 0(Zero) first in the Excel
program it will remove 0 (Zero) and show other digit. So
anyone can tell me what I have to do?
Thanks for help

 

[Arvi Laanemets]

Hi

When you want entries to remain numbers, and only view them with preceeding
0's, then format cell/range as custom "0000".

When you want to create values, where 0001<>1, then those must be strings
(You can't use them in formulas as numeric parameters then). You can
1) start the entry with apostrophe ('0001 is displayed and interpreted as
'0001')
2) convert the numeric entry using formula like
=TEXT(1,"0000")
or
=TEXT(A1,"0000")

 

[Kieran]

You need to change the cell format.
Cell formatting changes the way cells are displayed, not the content.

When you enter 0123 in excel, it assumes you are entereing a number and
and the default format for numbers is to truncate the leading zeros.

Select the offending cells and then got to the format menu, cells and
select custom. In the text box enter '0000' without the quotes.
Your numbers will now be right justified with zeros. If your numbers
are longer than 4 characters you will need to lengthen the '0000'