How do you format currency?


I am trying to format currency as $1,000,000.00 However, when I enter numbers as inputs for example they are entered and shown as 1000000 . How can I change this?

Hi John, you can do that with the FORMAT_LOCALIZED_DECIMAL formula function.

Thanks for the response.

1 Like