On Thu, 6 Jan 2005 07:43:04 -0800, "Chris"
wrote:

I have copyied a large number of parcel numbers into excel (maybe 3,000) and
I need to change the format in order to use them in another application. For
instance: 999999 needs to become 999-999 OR 99999 needs to become 099999.
How can this be done without changing each entry manually.

Thank you.

If you want a text string that you can then import into another application, in
an adjacent column put a formula of the type:

=TEXT(A1,"[99999]000-000;000000")

Change A1 to reflect the first cell of your parcel number list.

If you only want to change the FORMAT in Excel (without changing the underlying
number, then select the cells and do:

Format/Cells/Number Custom Type: [99999]000-000;000000


--ron