remove convert/extract the number from'12345.56; ie remove ' sign

  • Thread starter Thread starter WAN
  • Start date Start date
Hi

With the data in A1, enter in B1
=A1*1 or =A1+0

That will convert the Text of the number to a numeric value

If you have a large range of data to convert, type 1 into a blank cell
somewhere on your sheet. Copy that cell.
Now, mark the range of cells with text numbers>Paste Special>Multiply
 
Try this:

Select the range of "numbers"

From the Excel Main Menu:
<data><text-to-columns>
Click [Finish]

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Back
Top