Format value to show seperators

Here's an easy one, hopefully!! How can I set the format of a numeric to show the number in thousands, i.e. 1,123,321.00? I've tried all options I can find on the format tab for this but no success.

Thanks
Mark