AnsweredAssumed Answered

Importing Excel Percentages

Question asked by bookalaka on May 8, 2017
Latest reply on May 8, 2017 by philmodjunk

Hello,

 

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?

 

 

.78736157675099049946

Outcomes