Number to text field conversion

[wwyngaard]

I am trying to use a plugin to send email from filemaker. the plug in works fine but I am having trouble formating the body of the email the way I want it to look. Only text fields can be used in the body of the email but because it is an estimate I want to retain the $ and number formatting. Not losing the $ or trailing 0's.

Is there a calculation with a text result that will take a number field and have the correct formatting when finished. ie. $4,879.79

Thanks,

Wayne

[AndriesV]

Hi Wayne,

Assuming your values are below 999,999.99 the function below should work, if you need it to work for larger numbers you can add some more 'if' steps to allow for you maximum number:

"$" &

If([YourNumField] >= 1000,

Int([YourNumField]/1000) & "," & Round([YourNumField] - Int([YourNumField]/1000)*1000, 2),

Round([YourNumField],2))

Andries