Use B instead of G for billions.
under review
K
Kevin Minder
For example
want result in millions = 0.008B
shows answer
0.008B
I tried
want result in millions = 0.008B to millions
but that also shows the answer
0.008B
but I wanted it to show the answer
8M
Ideally that would also change the default Si notation for the remainder of the sheet.
Can I already force the answer to be displayed using a specific Si notation somehow?
Zac @ Soulver
under review
Zac @ Soulver
B is technically a unit of bytes. But we could possibly support lowercase B here, if you also include a currency symbol, like $0.008b