I have a column in my spreadsheet that contains a 5 digit number (the first 3 numbers are zeros which I would like to drop), and then some text. (see attached).
How can I remove the 3 leading zeros but leave everything else the same?
I have a column in my spreadsheet that contains a 5 digit number (the first 3 numbers are zeros which I would like to drop), and then some text. (see attached).
How can I remove the 3 leading zeros but leave everything else the same?
UPDATED Post: I attached my solution...used Text to columns again with your example and have the results without zeros. The actual numbers can be formatted differently to remove the display of decimals. Enjoy
EARLIER POST: Is attachment AWOL? Without seeing the actual file is like driving blind. Excel has a convert text to Columns in the Data Ribbon. It's a place to start - its simple...there are some VBA macros that can strip numbers from mixed format. pls provide exmaples