AnsweredAssumed Answered

How can I preserve exact decimal number value imported from Excel to FM?

Question asked by matus.cechvala@gmail.com on Dec 19, 2013
Latest reply on Dec 19, 2013 by matus.cechvala@gmail.com

Title

How can I preserve exact decimal number value imported from Excel to FM?

Post

     I have decimal numbers in Excel in text column. I can see and distinguish as different values e.g. 1.1 and 1.10 in Excel.

     If I import this text values to FM text (!) field after all I see the same value 1.1 in both cases. :( I need to preserve this exact values 1.1 and 1.10 so I can split them to 2 separate fields (e.g. position and subposition).

Outcomes