Changing figures format

Hi community,

Would like to ask if there is any that can result the issue below:

V_string format

Use select tool to change to double

May i know if there is anyway to maintain the original amount without reducing the number of decimal place after changin

Accepted answers

Not a perfect solution, but you can convert it to a Fixed Decimal instead with a size of 19.15 to get more decimal places than a double will allow.

I tried it lot of different ways since the latter value is very less its rounded instead of 0 if it was 1 it would still be there.

Hope this helps : )

Not a perfect solution, but you can convert it to a Fixed Decimal instead with a size of 19.15 to get more decimal places than a double will allow.

As @drew9 mentioned 🙂 you can use fixed decimal max precision is 16 decimal points (19.16).

Hope this helps : )