Numbers -format cells

[Guest]

Hi i want to enter in some codes such as 0001, 0002 but excel always changes
it to 1, 2. How can i have it as it is, 0001.

Thanks in advance

 

[David McRitchie]

Hi "Bonbon",
Format, cells, custom format, 0000

http://www.mvps.org/dmcritchie/excel/formulas.htm

 

[Guest]

There are several ways, but I prefer to just pre-format the cells for TEXT,
or enter a leading apostrophe before the first 0, such as '0001.....it will
not show up on any output and automatically converts the cell to TEXT format.

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

thx for the help and fast fast reply =]

Best regards
Bonbon

 

[David McRitchie]

You're welcome, but
see Chuck's answer, it is more appropriate to format as TEXT
for code, id, and identifying "numbers" that aren't really treated
as numbers to be used arithmetically.