Go Premium for a chance to win a PS4. Enter to Win

x
Solved

formula to edit numbers

Posted on 2014-01-22
Medium Priority
227 Views
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
0
Question by:route217

LVL 34

Accepted Solution

Rob Henson earned 2000 total points
ID: 39799890
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

Author Comment

ID: 39799915
Thanks rob....
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Suggested Courses
Course of the Month12 days, 5 hours left to enroll