DanielJohnson2

3 years agoQrew Trainee

# Formula to convert long numbers to short with abbreviation

Hi All,

In short, I need a formula to convert 123,000,000,000 to 123 B. I need it to cover all cases from 1,000,000 to 999,000,000,000,000.

If possible I would like 123,500,000,000 and 123,499,999,999 to both be 123.5, but for 123,400,000,000 to be 123.4 B. Since it's going to be a formula text field I thought maybe it would be easy to cover the case where if the right two characters are .0 then to slice them off.

Thoughts?

------------------------------

Daniel Johnson

------------------------------

In short, I need a formula to convert 123,000,000,000 to 123 B. I need it to cover all cases from 1,000,000 to 999,000,000,000,000.

If possible I would like 123,500,000,000 and 123,499,999,999 to both be 123.5, but for 123,400,000,000 to be 123.4 B. Since it's going to be a formula text field I thought maybe it would be easy to cover the case where if the right two characters are .0 then to slice them off.

Thoughts?

------------------------------

Daniel Johnson

------------------------------