In excel how do you format so 09561 for example the zero does not.

doing worksheet for ordering zeros at beginning of numbers disappear. How do
I format to keep zero in group of numbers ie 04581

Format>Cells>Number>Custom In the Type box, enter 00000

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"spoggy" <[email protected]> wrote in message
news:[email protected]...
> doing worksheet for ordering zeros at beginning of numbers disappear. How
> do
> I format to keep zero in group of numbers ie 04581

hi,
numbers with leading zeros should be entered as text.
when entering the number, enter an apostrophe first.
like this '04581. excel will hide the apostrophe and
keep the leading zero.
you could enter a custom format to force excel to show a
zero but this would only show a zero in the cell. in the
formula bar, the zero would not be there. in other words,
formating does not change the data. it changes the way it
looks on screen.

>-----Original Message-----
>doing worksheet for ordering zeros at beginning of
numbers disappear. How do
>I format to keep zero in group of numbers ie 04581
>.
>

Better than a custom number format, and also better than a laeding
apostrophe, is to format the cells as Text.

After selecting the cells you want treated this way, use the menu to choose
Format | Cells | Number & from the left hand panel (Category) choose Text &
click on OK.

Once you've done that, you can freely enter leading zeros without the need
to use an initial apostrophe



"spoggy" wrote:

> doing worksheet for ordering zeros at beginning of numbers disappear. How do
> I format to keep zero in group of numbers ie 04581

If you have a whole column to enter that way, then just highlight the
column, Format > Cells > NumberTab > Text > OK.........this way you don't
have to remember to type the leading apostrophe each time, nor do your
users........

Vaya con Dios,
Chuck, CABGx3


"spoggy" <[email protected]> wrote in message
news:[email protected]...
> doing worksheet for ordering zeros at beginning of numbers disappear. How
do
> I format to keep zero in group of numbers ie 04581