Possible format issue with numbers

[Gabocorreia95]

Hi Community 

I'm trying to get the formula tool to return the exact same number as the one in "Field1" however it is currently giving out 304978819902541440 instead of 304978819902541466

Any ideas? 

Best regards. 

[binu_acs · Accepted solution]

@Gabocorreia95 Are there warning messages in the result window? If you change the data type to V_String it would give you the correct result

[Gabocorreia95]

Thanks for your quick reply! 

I have tried the below however the result is being given out exponential notation please refer to the attached 

[binu_acs · Accepted solution]

@Gabocorreia95 Can you use the Select tool and change the data type to V_String then connect to the formula tool?

[Gabocorreia95]

Worked as  a charm, Thanks!!