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

  • Thread starter Thread starter WAN
  • Start date Start date
W

WAN

Method to convert 'nnnnn.nnn" to just the numbers without the apostrophe sign
 
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)
 
You must log in or register to reply here.

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

How to divide a number with "less than" sign? ie: <1/1000 = <0.001 3
convert number to text w/ error checking sign 1
removing the "-" sign in a calucation 7
Strange characters when converting from Word 2007 to Word 2003 6
Convert number to text as displayed 3
How to convert numbers with apostrophe's (ex. 219'2) to decimals? 2
Excel 2007 paste data, need to convert to numbers 3
sumproduct with 4 conditions 1

Back
Top