How do you format currency?

[John_Thompson]

Hello,

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?

[Mari]

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

[John_Thompson]

Thanks for the response.