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
route217Asked:
Who is Participating?
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Assuming the problem is because the source numbers are formatted as text, a simple

=A2*1

should do the necessary conversion for you.

Thanks
Rob H
0
 
route217Author Commented:
Thanks rob....
0
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.