asked on
EXCEL - how to remove leading zeros
I have an EXCEL text formatted column with leading zeroes. How can I easily remove them. For example;
Column A Column B (expected results)
01 1
200 200
03 3
201 201
02 2
Column A Column B (expected results)
01 1
200 200
03 3
201 201
02 2
Microsoft Excel
Last Comment
Rob Henson
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Select the range and to the left of the first cell there will be an Exclamation mark error warning. Click on it and select Convert to Number from the available options.
Thanks
Rob H
Thanks
Rob H
Has your question been solved?
(Some of us rely on points to keep premium status and it's the end of the month, so it would be helpful if you could check the answers and close the question or post another comment before the month is up. Thanks! :-) )