Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 3
remove convert/extract the number from'12345.56; ie remove ' sign

Method to convert 'nnnnn.nnn" to just the numbers without the apostrophe sign
#2
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 2,480
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

#3
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 2,118
remove convert/extract the number from'12345.56; ie remove ' sign

Try this:

Select the range of "numbers"

<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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Vipul New Users to Excel 1 January 8th 08 02:34 PM Freshman Excel Worksheet Functions 7 May 21st 07 11:10 AM Sydney sidekick Excel Discussion (Misc queries) 3 October 5th 06 07:12 PM Cr character on numbers Excel Worksheet Functions 3 March 10th 06 10:34 PM Karl Burrows Excel Discussion (Misc queries) 23 June 25th 05 10:37 PM

All times are GMT +1. The time now is 09:30 PM.