Display comma's

[Jaren Meier]

Dumb question. How can i show a comma in a "Show Custom Dialog" option. The calculated field that includes a number, but the result is text. Here is the example.

"You have chosen" & QUOTE_amount & " as your final quantity, is this correct?"

(Calculation result must be Text)

This is what I get:

You have chosen 20000 as your final quantity, is this correct?

I need to make the 20000 look like 20,000

[mr_vodka]

Not a dumb question at all. Since the field QUOTE_amount is a number field and does not have commas in it itself, you need to have a text field that diplays the number field with the commas in it and reference that field in your Custom dialog box.

To achieve that conversion easily, try a custom function like this one.

http://www.briandunning.com/cf/483