I am having a problem with the excel figures being imported are different from my FM calculations and is causing a difference in my reports. On a previous post from another user a suggestion was made about using an auto calc feature to parse out the additional integers. I have tried numerous imports without success any ideas?.
Thanks in advance.
"If you don't then you could store only the 2-place rounded figure by adding an auto enter calc so that the raw figure replaces itself on import."
How on import can I only get the first four digits?