Convert number to standard form

Question

I need to change numbers to be in standard form of 7 s.f.

e.g. from 2931131555743 to 2.931132E+12.

I can leave the final value as a string however it needs to match the above format exactly. My current thought process is to round it to 2931132000000 then strip it apart as a string however this will cause problems if the number before the E is rounded to 0, is there another way to do it?

Thanks

afv2688 · Accepted Answer

Hello @fallon1,

added the function for values >1 now:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards