Confuddled
New Member
- Joined
- Feb 22, 2017
- Messages
- 8
Hi all!
I'm using
=TEXT(S146,"0.0,,") & " million"
to convert [TABLE="width: 162"]
<tbody>[TR]
[TD="class: xl69, width: 162"] £ 354,691,359 to 354.7 million
but what do I use to change it to billions?
Thank you
Confuddled
[/TD]
[/TR]
</tbody>[/TABLE]
I'm using
=TEXT(S146,"0.0,,") & " million"
to convert [TABLE="width: 162"]
<tbody>[TR]
[TD="class: xl69, width: 162"] £ 354,691,359 to 354.7 million
but what do I use to change it to billions?
Thank you
Confuddled
[/TD]
[/TR]
</tbody>[/TABLE]