I have a field that I would like to concatenate two numbers. Both numbers are spend levels.

I have them looking like this $21000, how do I get the comma in ($21,000)?

Thanks for any help.

You can apply formatting to the field (right click on it, choose Number format, choose format as decimal, use notation, choose your currency symbol, under seperators, select to use a thousands seperator, and insert the comma.

Genx: I didn't mention that this is a text field. The actual info looks like this:

$21000 / $21000

I could put both fields in seperated by a "/" but it doesn't look as clean.

Why not? If you use merge fields, it should look exactly like a calculation would.

I must confess I didn't realise that you could mix numbers and text in a merge field like this:

<>/<>

I had to specify the thousands separator and currency symbol for the merge field.

Where number1 and number2 are defined as number fields and the "/" separator I keyed manually. The trick here was to manually type the "/<>2" text as an extension to inserting a merge field (number1) on the layout.

I think a convenient way to do this would be:

1. Select the type tool and click on the layout to create a new text object;

2. Select Insert > Merge Field... > number1;

3. Type "/";

4. Select Insert > Merge Field... > number2;

5. Click outside the text object;

6. Select Format > Number... and format the fields as currency.

Note:

1. Formatting applies to all number fields merged in the text object;

2. There's a keyboard shortcut to select Insert > Merge Field...

Thanks guys that worked great. Another lesson learned.