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