problem of recognition of numbers in Excel

[Guest]

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.

 

[MDubbelboer]

you've got numbers stored as text

put the number 1 in a cell. copy the cell, highlight the range o
numbers stored as text and right click. paste special->multipl

 

[daddylonglegs]

Try selecting a column of these "numbers" and use

Data > Text to Columns > Finish

to conver

 

[JR573PUTT]

Did you try to use the text to column function on the numbers that ar
text, this usually is a quick fix. I simply choose text to columns
then next, next finsh, choosing fixed width or delimited works sinc
you are really spliting the numbers again

 

[Paul Lautman]

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?