[Cheri]

I have a spreadsheet with ID numbers. We only use 6 numbers but the IDs send
to me contain 3 zeros in front I don't need (000051585) How can I format the
numbers to drop off those first 3 zeros?

[Kevin B]

Insert a column to the right of your id numbers, and use the following
formula to modify the ID Numbers (Assuming that all the ID's are labels and
not values). Change cell A1 to the starting ID value cell:

=RIGHT(A1,LEN(A1)-3)

Copy the formula down the column to the last ID. Then copy the formula
column and do a PASTE/SPECIAL/VALUES over the original ID column.

Delete the inserted column with the formulas when done.

--
Kevin Backmann


"Cheri" wrote:

I have a spreadsheet with ID numbers. We only use 6 numbers but the IDs send
to me contain 3 zeros in front I don't need (000051585) How can I format the
numbers to drop off those first 3 zeros?

[Cheri]

Isn't there an easier way. I've done the copy cut and paste thing. The
column is formatted as "general"

"Kevin B" wrote:

Insert a column to the right of your id numbers, and use the following
formula to modify the ID Numbers (Assuming that all the ID's are labels and
not values). Change cell A1 to the starting ID value cell:

=RIGHT(A1,LEN(A1)-3)

Copy the formula down the column to the last ID. Then copy the formula
column and do a PASTE/SPECIAL/VALUES over the original ID column.

Delete the inserted column with the formulas when done.

--
Kevin Backmann


"Cheri" wrote:

I have a spreadsheet with ID numbers. We only use 6 numbers but the IDs send
to me contain 3 zeros in front I don't need (000051585) How can I format the
numbers to drop off those first 3 zeros?