Text to Number
You can do this without a formula.
Select the range of cells in question
Goto DataText to Columns
Select Fixed widthNext
Set the breakline after the 0:
'0 | 14564
Click Next
In Step 3 of the wizard select Do not import
Click Finish
If you do want a formula:
=--MID(A1,3,255)
--
Biff
Microsoft Excel MVP
"Talladega" wrote in message
...
Hi
I have a series of numbers in each row with an apostrophe in the front.
How
do i create a formula that can take out the apostrophe, so the zero in the
front of the number disappear leaving only numbers.
ex: '014564 -- 14564
'077454 -- 77454
'023457 -- 23457
'077875 -- 77875
|