JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,643
- Office Version
- 365
- Platform
- Windows
I need to format numbers from 0 to 10^24 or more. Here's what I'd like
0 - 999 -> as is
1,000 - 999,000 -> xxx thousand
1,000,000 - 999,000,000 -> xxx million
1,000,000,000 - 999,000,000,000 -> xxx billion
... and so on
Is there a formatting string that will do that?
Is there a built-in function that will convert the number into that string or does anyone have a UDF that will do that.
I don't care whether the result is a number or a string.
0 - 999 -> as is
1,000 - 999,000 -> xxx thousand
1,000,000 - 999,000,000 -> xxx million
1,000,000,000 - 999,000,000,000 -> xxx billion
... and so on
Is there a formatting string that will do that?
Is there a built-in function that will convert the number into that string or does anyone have a UDF that will do that.
I don't care whether the result is a number or a string.