remove convert/extract the number from'12345.56; ie remove ' sign
Method to convert 'nnnnn.nnn" to just the numbers without the apostrophe sign
|
remove convert/extract the number from'12345.56; ie remove ' 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 numbersPaste SpecialMultiply -- Regards Roger Govier "WAN" wrote in message ... Method to convert 'nnnnn.nnn" to just the numbers without the apostrophe sign |
remove convert/extract the number from'12345.56; ie remove ' sign
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) "WAN" wrote in message ... Method to convert 'nnnnn.nnn" to just the numbers without the apostrophe sign |
All times are GMT +1. The time now is 01:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com