Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Drop leading zeros in a cell that contains both numbers AND text

1

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?

Answer
Discuss

Answers

1
Selected Answer

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

Discuss

Discussion

The attachment was not Excel, I have now added that so you should be able to see it.  I previously tried what you had suggested, and that does not work in this case.
JenS (rep: 4) Dec 15, '16 at 1:10 pm
THANK YOU!
JenS (rep: 4) Dec 16, '16 at 3:08 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login