View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman Paul Lautman is offline
external usenet poster
 
Posts: 85
Default 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?