Text to Number

  • Thread starter Thread starter Jez
  • Start date Start date
J

Jez

I have the following numbers that have been imported from
a Text file.

159-356-45 this number is imported as text and I am
unbale to convert it to 15935645. Formating doesn't work
nor does the TEXT function. Please help

Jez
 
One way, use
=SUBSTITUTE(A1,"-","")
in another column and copy down,
Copy > Paste Special > Values over the original import,
Regards,
Alan.
 
assuming the number format is consistant, and the data is
in cell A1, enter the following formula in cell B1:

=LEFT(A1,3) & MID(A1,5,3) & RIGHT(A1,2)
 
Try copying, then paste special and choose add. This may
work. If it doubles the number, then divide by 2.
 
Back
Top