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

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

--


Gary Keramidas
Excel 2003


"Dee" wrote in message
...
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

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

"Dee" wrote:

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

"Dee" wrote in message
...
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.