AnsweredAssumed Answered

Changing a field from Text to Number

Question asked by dwirony on Jun 29, 2018
Latest reply on Jun 29, 2018 by philmodjunk

I'd like to change a field that has historically been a Text field to a Number field - when I export from FMP to Excel, I have to always manually make this change, so I'd like to fix it at the source.

 

My question is - If my record is stored as "12.35", will changing it to a number strip away the decimals? My fear is that I'll change the field from Text to Number and lose my decimals places (changing "12.35" to "12", etc.). How can I ensure this doesn't happen?

Outcomes