Is there a formula to remove the leading zeros? I have tried to change the format of the column but nothing works…the only way I found is to double click inside the cell to make the lead zero disappear. Problem is there’s 1400 lines I have to double click on…numbers start on A3. Thanks in advance
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Remove leading zeros
- Thread starter Tonyk1051
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,418
- Office Version
- 365
- Platform
- Windows
Are the values all numbers, or are there other non-numeric characters in them?
If they are all numeric, all you need to do is changing the format of the column to some numeric option, highlight the column, go to the Data menu and select "Text to Columns", and then click "Finish".
This should drop all leading zeroes from valid numbers.
If they are all numeric, all you need to do is changing the format of the column to some numeric option, highlight the column, go to the Data menu and select "Text to Columns", and then click "Finish".
This should drop all leading zeroes from valid numbers.
Upvote
0
Holy cow it worked! Thanks man
Upvote
0
Similar threads
- Solved
- Solved
