Link to home
Create AccountLog in
Avatar of tmajor99
tmajor99

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
SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Hi,

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!  :-)  )
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