Forum Discussion
Excel - Data from Text
When I import from a text file - DATA FROM TEXT/CVS, for some reason the numbers are not as numbers, so when I enter "auto sum" at the bottom, it's not adding the numbers I need it to. How do I fix ...
Select your column, then go to Data, Text to Columns. Hit Next three times & select 'General', then Finish. Right click the still selected column & format the column to the Number format you want.
Rusty Dane that's great - I never knew that!!! thank you!!