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.

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

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

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

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?