Forum Discussion

Rob Williams's avatar
Rob Williams
Icon for Microsoft rankMicrosoft
Jan 02, 2024

Currency formatting in a cell that has a formula

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?  ...

Resources