I haven't been able to find a fix, but it looks like as the number gets to a certain size it'll automatically set it to scientific notation form (just a guess here, someone on the forum can correct me as to what the functionality should be).
I'm making an assumptions in that you expecting to copy directly from Anaplan and paste it into another system. As a possible workaround/alternative:
- Would you be able to export out the numbers into excel and then copy into the other system
- Control and paste the module into excel, format the cell and then copy it into another system
This has been an issue for quite sometime and off lately Anaplan has come up with the additional syntax parameter of method in ROUND functionality - NORMAL or EXACT , here EXACT does the trick. You can take the approach @Akhtar.shahbaz has suggested. But I would like to elaborate on the issue and let's see if this should be the real behaviour from Anaplan. Post/Link @usman.zia has shared about 8 digit precision seems to be valid for such cases including optimizer but let me share my views on the below issue - If we
Input 7 digit number with 0 decimal places - why does anaplan take one decimal place value when decimal places are set to be zero?
Input 8 digit number with 0 decimal places - Although the number looks fine in the Cell but in the backend Anaplan stores it in Scientific notation
Input 7 digit number with 3 decimal places - Looks fine
Input 8 digit number with 3 decimal places - Scientific notation
Well it really comes down to 8 digit number threshold (Decimal places don't matter) - post which it changes it to scientific notation.