Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 10th 08, 01:19 PM posted to microsoft.public.excel.worksheet.functions
Wan Wan is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 3
Default 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   Report Post  
Old January 10th 08, 01:28 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default 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   Report Post  
Old January 10th 08, 01:38 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove hyperlink if 'remove' option is disabled Vipul New Users to Excel 1 January 8th 08 03:34 PM
Remove & extract name in one cell Freshman Excel Worksheet Functions 7 May 21st 07 11:10 AM
how do I remove the % sign in cells without using the % icon Sydney sidekick Excel Discussion (Misc queries) 3 October 5th 06 07:12 PM
remove cr character from a + number and change number to - 159cr Cr character on numbers Excel Worksheet Functions 3 March 10th 06 11:34 PM
Extract Unique Values, Then Extract Again to Remove Suffixes Karl Burrows Excel Discussion (Misc queries) 23 June 25th 05 10:37 PM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017