How do I eliminate leading zeros from downloaded data?
I have downloaded data from another source and the customer numbers are of
different numeric lengths (ex- 345 and 34567). Excel preceeded the numbers with zeros to make the character length equal to 8. How to I drop the preceeding zeros? Thanks! |
select the column/range that contains leading zeros
then on menu go to data--text to columns-- delimited Next next and hit Finish, This will convert all those cells to numbers OR type 1 on an emplty cell select that cell and hit ctrl C Now select the column/range edit paste special values and Multiply "Vanessa" wrote in message ... I have downloaded data from another source and the customer numbers are of different numeric lengths (ex- 345 and 34567). Excel preceeded the numbers with zeros to make the character length equal to 8. How to I drop the preceeding zeros? Thanks! |
there are two main possibilities
the number may be just formated at having extra leading zeros <format<cell<number select general if the zeros are still there, the cell probably is probably text rather than numeric. double click on one of the cells with the leading zeros and hit enter It may go back to numeric if so, enter 1 in an empty cell, copy, select all of the cells with the leading zeros and paste special multiply if not use a helper column and enter = value(trim(a1)) copy to the end of your data copy this new column and paste special value over the existing data "Vanessa" wrote: I have downloaded data from another source and the customer numbers are of different numeric lengths (ex- 345 and 34567). Excel preceeded the numbers with zeros to make the character length equal to 8. How to I drop the preceeding zeros? Thanks! |
All times are GMT +1. The time now is 01:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com