Showing results for 
Search instead for 
Do you mean 

ACT 2013 - import numbers

New Member
Posts: 7
Country: Australia

ACT 2013 - import numbers

I am trying to import data from a very simple excel spread sheet (8 names only). It works fine except that it will not import 2 columns of numbers. It imports numbers from 2 other columns and the only difference seems to be that the numbers that are not importing are larger (5 digits). The other numbers that do import are only 2 digits. The format of both the excel spreadsheet and the ACT field is number. any ideas? thanks
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: ACT 2013 - import numbers

I tested this and had no issues importing large numbers into ACT! number fields. Some questions:
- What are the numbers and how do they display in Excel?
- Are the number fields you are trying to import into already populated?
- In the field properties for these number fields (Tools > Define Fields), do you have a Default Value selected?

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.