how to show numbers that begin with 0 in excel

[Dee]

I need to type numbers into an excel spreadsheet some of them begin with a
zero some do not. How can I have excel show the 0 in the numbers that begin
with 0. If I type 0236547 the number shows as 236547. I don't want all the
numbers I type to begin with zero.

I am using Excel 2003. Thanks very much for your help.

Best regards,

Dee

 

[Gary Keramidas]

use a custom format with how ever many digits you need, 000000

 

[scottay]

you need to put a an apostraphe before the number. you should type '0236547

 

[John Smith]

I need to type numbers into an excel spreadsheet some of them begin with a
zero some do not. How can I have excel show the 0 in the numbers that
begin
with 0. If I type 0236547 the number shows as 236547. I don't want all the
numbers I type to begin with zero.

I am using Excel 2003. Thanks very much for your help.

Best regards,

Dee

Do you need to do mathematical calculations on these numbers, or are they
some sort of reference or item number? If the latter, just format as text.