May 28 2019 06:50 AM
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 the numbers without re-typing all of them?
May 28 2019 07:50 AM
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.
May 28 2019 09:53 AM
@Rusty Dane that's great - I never knew that!!! thank you!!
May 28 2019 09:56 AM
@Rusty Dane While waiting for a reply I just found that "opening" the text file in excel instead of importing it leaves the number(s) intact and works like the prior versions of excel used to work.
thank you!!