Numbers -format cells

B

Bonbon

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
 
C

CLR

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
 
B

Bonbon

thx for the help and fast fast reply =]

Best regards
Bonbon

David McRitchie said:
Hi "Bonbon",
Format, cells, custom format, 0000

http://www.mvps.org/dmcritchie/excel/formulas.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Bonbon said:
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
Click to expand...
Click to expand...
 
D

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