Currency formatting in a cell that has a formula

Question

I have the following formula,&nbsp;=WEBSERVICE($B$3&amp;"/"&amp;[@Ticker]&amp;"/MCAP") which wraps an API in a webservice.&nbsp; The result is a number,&nbsp;

47392920605

&nbsp;
How can I format this as follows?&nbsp; $47,392,920,605&nbsp; I have tried formatting it via the tool bar and format painter, with no success.
Rob

hansvogelaar · Answer

Rob Williams&nbsp;
Does this work?
&nbsp;
=--WEBSERVICE($B$3&amp;"/"&amp;[@Ticker]&amp;"/MCAP")

Forum Discussion

Currency formatting in a cell that has a formula

Share

Resources