formula to edit numbers

Hi expert's excel 2007

I need a formula to remove the 000 values at the start of  a number....

so if we have...
1. 00097578678 then return 97578678
2. 0056478 then return 56478
3. 0767676 then 767676

the first values in column a2 and result in b2
Who is Participating?
Rob HensonConnect With a Mentor Finance AnalystCommented:
Assuming the problem is because the source numbers are formatted as text, a simple


should do the necessary conversion for you.

Rob H
route217Author Commented:
Thanks rob....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.