 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008removing comma in data string
I have a string of numbers, but they've been entered as: 357,041 332,224 341,038 etc. Basically I'd just like to convert them to numbers so I can add, subtract, etc. The problem is that as they are right now, they are stored as text, and I can't figure out how to fix that (format cells > number does nothing). Please help. Check your other post. > I have a string of numbers, but they've been entered as: > [quoted text clipped - 10 lines] > > Please help.  SignatureDave Peterson Where Dave? Can't find it under this author. SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Check your other post. > [quoted text clipped - 12 lines] >> >> Please help. In .programming. > Where Dave? > Can't find it under this author. [quoted text clipped - 26 lines] > > > > Dave Peterson SignatureDave Peterson No wonder ... never go there! SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > In .programming. > [quoted text clipped - 28 lines] >> > >> > Dave Peterson Try this.......... Enter a 1 in an unused cell Copy it Then Highlight the string to be changed and do PasteSpecial > Multiply Vaya con Dios, Chuck, CABGx3 > I have a string of numbers, but they've been entered as: > [quoted text clipped - 10 lines] > > Please help. > Try this.......... > Enter a 1 in an unused cell [quoted text clipped - 19 lines] > > > Please help. Doesn't work. I've tried using the n() function to convert the text into a number, but it just gives me 0.00 I've gotten rid of the commas now (using Find + Replace - Thanks Dave!), but still can't format as anything but text. -Jaremy >> > 357,041 >> > 332,224 >> > 341,038 Highlighting the ranges and then copying a blank, unused cell and Paste Special > Add will get rid of the commas and convert to a number in one. SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >> Try this.......... >> Enter a 1 in an unused cell [quoted text clipped - 27 lines] > > -Jaremy I think that you meant Paste Special > Add didn't you Chuck? Time for another coffee SignatureRegards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Try this.......... > Enter a 1 in an unused cell [quoted text clipped - 18 lines] >> >> Please help. > I think that you meant Paste Special > Add didn't you Chuck? > [quoted text clipped - 34 lines] > > >> Please help. He meant multiply. Since multiplying any number by 1 = that number. Unfortunately, when I do that I get a #VALUE error, since the cell in question is actually text, not a number. > He meant multiply. Since multiplying any number by 1 = that number. > Unfortunately, when I do that I get a #VALUE error, since the cell in > question is actually text, not a number. So he did. I was so sure that Chuck would have written copy a *black* cell that I failed to read the post properly. My appologies Chuck - it's me that needs the coffee! SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >> I think that you meant Paste Special > Add didn't you Chuck? >> [quoted text clipped - 38 lines] > Unfortunately, when I do that I get a #VALUE error, since the cell in > question is actually text, not a number. Having a bad day! > So he did. I was so sure that Chuck would have written copy a *black* > cell was of course meant to be *BLANK* day! SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >> He meant multiply. Since multiplying any number by 1 = that number. >> Unfortunately, when I do that I get a #VALUE error, since the cell in [quoted text clipped - 48 lines] >> Unfortunately, when I do that I get a #VALUE error, since the cell in >> question is actually text, not a number. No problem Sandy......come on over to my house and we'll brew up a new potfull. My day is almost done here now, so I'm off to the Computer Store, <g> Vaya con Dios, Chuck, CABGx3 > > He meant multiply. Since multiplying any number by 1 = that number. > > Unfortunately, when I do that I get a #VALUE error, since the cell in [quoted text clipped - 47 lines] > > Unfortunately, when I do that I get a #VALUE error, since the cell in > > question is actually text, not a number. These things are always a problem, and the same procedure never seems to work on all of them...........maybe try Data > TextToColumns, sometimes that will break the spell.........then maybe the 1-multiply thing Vaya con Dios, Chuck, CABGx3 > I have a string of numbers, but they've been entered as: > [quoted text clipped - 10 lines] > > Please help. Another way to try......... =(LEFT(A1,3)&RIGHT(A1,3))*1 Vaya con Dios, Chuck, CABGx3 > I have a string of numbers, but they've been entered as: > [quoted text clipped - 10 lines] > > Please help. >I have a string of numbers, but they've been entered as: > [quoted text clipped - 10 lines] > >Please help. Wild guess -- you got these values from a web page. If so, there may be a <nbsp> embedded. Try this: =--TRIM(SUBSTITUTE(A1,CHAR(160),"")) = --ron > >I have a string of numbers, but they've been entered as: > [quoted text clipped - 21 lines] > = > --ron Amazing. Thanks greatly, Ron! This fixed the problem 100%. You're a life-saver. >Amazing. Thanks greatly, Ron! This fixed the problem 100%. > >You're a life-saver. Glad to help. Thanks for the feedback. --ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.