Currency formatting in a cell that has a formula

Microsoft

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

47392920605

 

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

Rob

1 Reply

@Rob Williams 

Does this work?

 

=--WEBSERVICE($B$3&"/"&[@Ticker]&"/MCAP")