how to show numbers that begin with 0 in excel

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to format cell in excel for 12 digit number starting with a 0 2
Preformatting Excel Prior to Opening Spreadsheet 1
how do i enter a negative number sequence with spaces in excel 1
Displaying zeros in cells 2
How do I put spaces in a field 1
How do I type a # (01020) in Excel & have the 1st 0 stay? 5
Starting with a zero? 3
How do I format cells to show the number 0 as first number in seri 2

Top