I am uploading these numbers to an application
that stores and displays 1543 as 001543.

1543 becomes 001543
17626 becomes 017626

I need to convert all numbers from 1000 to 19000 to show as 001000 to
019000. This column may include some or all of these numbers.

I am trying to avoid converting to text but don't know how to do that either
other than manually. I am really an out of work actor so I require explicit
instructions please.

Thanks a million!

Select the cells (or the entire column if you think your list will grow),
click Format/Cells on Excel's menu bar, click Custom in the Category listing
and type 000000 in the field labeled Type, then OK back to the worksheet.

Rick


"Professor_Higgins" <(E-Mail Removed)> wrote in
message news:08ACFE43-C9E4-49CA-8AD2-(E-Mail Removed)...
>I am uploading these numbers to an application
> that stores and displays 1543 as 001543.
>
> 1543 becomes 001543
> 17626 becomes 017626
>
> I need to convert all numbers from 1000 to 19000 to show as 001000 to
> 019000. This column may include some or all of these numbers.
>
> I am trying to avoid converting to text but don't know how to do that
> either
> other than manually. I am really an out of work actor so I require
> explicit
> instructions please.
>
> Thanks a million!

Mr. Rothstein -

Awesome answer. Worked perfectly.

Thank you very much~!

"Rick Rothstein (MVP - VB)" wrote:

> Select the cells (or the entire column if you think your list will grow),
> click Format/Cells on Excel's menu bar, click Custom in the Category listing
> and type 000000 in the field labeled Type, then OK back to the worksheet.
>
> Rick
>
>
> "Professor_Higgins" <(E-Mail Removed)> wrote in
> message news:08ACFE43-C9E4-49CA-8AD2-(E-Mail Removed)...
> >I am uploading these numbers to an application
> > that stores and displays 1543 as 001543.
> >
> > 1543 becomes 001543
> > 17626 becomes 017626
> >
> > I need to convert all numbers from 1000 to 19000 to show as 001000 to
> > 019000. This column may include some or all of these numbers.
> >
> > I am trying to avoid converting to text but don't know how to do that
> > either
> > other than manually. I am really an out of work actor so I require
> > explicit
> > instructions please.
> >
> > Thanks a million!
>
>