Forum Discussion
Text file import to excel
I import a text file into excel with about 60 employees and have no issues. Sometimes when I import a similar file with 900 employees, I noticed some of the amounts do not appear as numbers. Instead t...
That makes sense. I will try a helper column. Usually when I select a set of data, there is an icon that appears and it allows conversion to number. I work with employee benefits. Usually to double check my amounts i select data in my column to compare totals. In this case after the import when I selected the column it was not giving sum of the data and instead the data in that column seemed like they were text.
Let me know if it does the trick.
I'm retired now, but during my career spent several years as the director of the HR and Payroll database for a major corporation......so I know the kind of data you're dealing with intimately.
- Thanks I really appreciate it. It worked