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?
|