Thread: Text to Number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Talladega Talladega is offline
external usenet poster
 
Posts: 17
Default Text to Number

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