Text to Number

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
 
A

Alan

One way, use
=SUBSTITUTE(A1,"-","")
in another column and copy down,
Copy > Paste Special > Values over the original import,
Regards,
Alan.
 
R

Randy

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)
 
K

KF

Try copying, then paste special and choose add. This may
work. If it doubles the number, then divide by 2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Converting URLs in comments to Markdown-formatted links 2
How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Inconsistent formatting of section numbers 0
Removing Line Numbers 4
Formating bolded text exclusively. 0
Select Text to End of Footnote 9

Top