| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem of recognition of numbers in Excel
After using the split column features in Excel, I've run into a problem that
the numbers put into the new column are no longer recognized as numbers. For instance, when running a SUM function the result is 0.00. The problem is only solved when I re-type the numbers (which "look" exactly the same before and after typing). Any help? I have too many entries to re-type them all. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem of recognition of numbers in Excel
you've got numbers stored as text. put the number 1 in a cell. copy the cell, highlight the range of numbers stored as text and right click. paste special-multiply -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=562636 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem of recognition of numbers in Excel
Try selecting a column of these "numbers" and use Data Text to Columns Finish to convert -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=562636 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem of recognition of numbers in Excel
Did you try to use the text to column function on the numbers that are text, this usually is a quick fix. I simply choose text to columns, then next, next finsh, choosing fixed width or delimited works since you are really spliting the numbers again. -- JR573PUTT ------------------------------------------------------------------------ JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587 View this thread: http://www.excelforum.com/showthread...hreadid=562636 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem of recognition of numbers in Excel
dvandani wrote:
After using the split column features in Excel, I've run into a problem that the numbers put into the new column are no longer recognized as numbers. For instance, when running a SUM function the result is 0.00. The problem is only solved when I re-type the numbers (which "look" exactly the same before and after typing). Any help? I have too many entries to re-type them all. Excel doesn't have "split column features". There are various in which one can split the data in a column using formulas, VBA, Text to Columns, ... Would you care to tell us precisely how you are splitting the data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| how do I enter numbers in excel using speech Recognition? | New Users to Excel | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
