how to get left side zeros to show i.e. 00045

D

Dave Peterson

You have a few choices.

To keep the entry a real number, you can give that cell (or range of cells) a
custom number format.

In xl2003 menus:
Select the range
Format|Cells|Number tab|custom category
type
00000
and finish up

You can also treat the entry as text.

You can preformat the cell as text (also on that Number tab in the format|cells
dialog, then do the data entry.

Or you can start your entry with an apostrophe: '00045



tcole wrote:
 

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 do I change auto formatting to allow a 0 as the first number 0
how to insert symbol or sign on the top right of any number 2
Dates, And Their Corresponding Numbers: How To Show ? 0
Adding an apostrophe to a column of numbers 5
How can you place a Zero at the beginning of a numbr (Ex. D.L. #). 0
how to put a number with more than 15 digits in a cell 0
How do I stop Excel from dropping leading zeros? 2
Format Cells for Hexidecimal (custom?) 1

Top