Home |
Search |
Today's Posts |
#1
|
|||
|
|||
converting copied data to numbers in excel xp
I tryed following the instructions for converting text to numbers and it
didn't work. I am sure someone has had this problem. Any help appreciated. thanks, kris |
#2
|
|||
|
|||
Hi Kris
Have you try this Copy a empty cell Select the cells with text values Right click on the selection Choose Paste Special ..... Add OK ESC -- Regards Ron de Bruin http://www.rondebruin.nl "knutsenk" wrote in message ... I tryed following the instructions for converting text to numbers and it didn't work. I am sure someone has had this problem. Any help appreciated. thanks, kris |
#3
|
|||
|
|||
Kris
If Ron's method does not do the job, perhaps you have some junk in the cells. Extra spaces, non-breaking spaces to name a couple. Depends upon where the text is imported from. Post back if that is the case. Gord Dibben Excel MVP On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin" wrote: Have you try this Copy a empty cell Select the cells with text values Right click on the selection Choose Paste Special ..... Add OK ESC -- Regards Ron de Bruin http://www.rondebruin.nl "knutsenk" wrote in message ... I tryed following the instructions for converting text to numbers and it didn't work. I am sure someone has had this problem. Any help appreciated. thanks, kris |
#4
|
|||
|
|||
Thanks for the assistance Ron, however that did not work either. I am
attaching a couple of numbers from the sheet I am trying to convert. 3 5 16 11 24 I tried copying these back from here to the Excel sheet, matching destination, and then the multiply solution worked. So I will copy out of the worksheet into another application and back again. However, I often need to do this so if you have an easier method I am all ears. Thanks in advance for your help. Kris Knutsen "Gord Dibben" wrote: Kris If Ron's method does not do the job, perhaps you have some junk in the cells. Extra spaces, non-breaking spaces to name a couple. Depends upon where the text is imported from. Post back if that is the case. Gord Dibben Excel MVP On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin" wrote: Have you try this Copy a empty cell Select the cells with text values Right click on the selection Choose Paste Special ..... Add OK ESC -- Regards Ron de Bruin http://www.rondebruin.nl "knutsenk" wrote in message ... I tryed following the instructions for converting text to numbers and it didn't work. I am sure someone has had this problem. Any help appreciated. thanks, kris |
#5
|
|||
|
|||
knut
Download Chip Pearson's CELLVIEW add-in from http://www.cpearson.com/excel/CellView.htm Load through ToolsAdd-ins. Select the data and Chip's add-in will show you what the characters in the cells are. You may be able to clear them using TRIM or CLEAN. Most likely David McRitchie's TRIMALL macro will be of greatest assistance. Cleans up what TRIM and CLEAN miss. http://www.mvps.org/dmcritchie/excel/join.htm#trimall Gord Dibben Excel MVP On Sat, 2 Apr 2005 15:35:02 -0800, "knutsenk" wrote: Thanks for the assistance Ron, however that did not work either. I am attaching a couple of numbers from the sheet I am trying to convert. 3 5 16 11 24 I tried copying these back from here to the Excel sheet, matching destination, and then the multiply solution worked. So I will copy out of the worksheet into another application and back again. However, I often need to do this so if you have an easier method I am all ears. Thanks in advance for your help. Kris Knutsen "Gord Dibben" wrote: Kris If Ron's method does not do the job, perhaps you have some junk in the cells. Extra spaces, non-breaking spaces to name a couple. Depends upon where the text is imported from. Post back if that is the case. Gord Dibben Excel MVP On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin" wrote: Have you try this Copy a empty cell Select the cells with text values Right click on the selection Choose Paste Special ..... Add OK ESC -- Regards Ron de Bruin http://www.rondebruin.nl "knutsenk" wrote in message ... I tryed following the instructions for converting text to numbers and it didn't work. I am sure someone has had this problem. Any help appreciated. thanks, kris |
#6
|
|||
|
|||
Sometimes this works.........
Highlight the column, Data Text to Columns Delimited Next and un-check all delimiters Finish Vaya con Dios, Chuck, CABGx3 "knutsenk" wrote in message ... Thanks for the assistance Ron, however that did not work either. I am attaching a couple of numbers from the sheet I am trying to convert. 3 5 16 11 24 I tried copying these back from here to the Excel sheet, matching destination, and then the multiply solution worked. So I will copy out of the worksheet into another application and back again. However, I often need to do this so if you have an easier method I am all ears. Thanks in advance for your help. Kris Knutsen "Gord Dibben" wrote: Kris If Ron's method does not do the job, perhaps you have some junk in the cells. Extra spaces, non-breaking spaces to name a couple. Depends upon where the text is imported from. Post back if that is the case. Gord Dibben Excel MVP On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin" wrote: Have you try this Copy a empty cell Select the cells with text values Right click on the selection Choose Paste Special ..... Add OK ESC -- Regards Ron de Bruin http://www.rondebruin.nl "knutsenk" wrote in message ... I tryed following the instructions for converting text to numbers and it didn't work. I am sure someone has had this problem. Any help appreciated. thanks, kris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Merging data from an excel worksheet into an excel template | Excel Worksheet Functions | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |