dog

Q: Why do I lose precision in numbers? Why is “123456789” shown as “1.23e+08”?

A: This is quite annoying, especially when you want to quickly copy and paste values to excel or word. To fix this, we need to use format command.

format number %9.0f

**Shows 9 digits

Now you can copy and paste “123456789” instead of “1.23e+08.”

Advertisement