View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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