I’m having problems with a dollar field from an InfoPath
form, displaying properly in the SharePoint Designer generated e-mail.
Everything is fine, unless the dollar amount ends in “.00”, then all I get is a
single decimal place (for example, I have numbers that display as “$1,1200.0”;
$450.0; and $7000.0”).
My original field to capture the amount is Text Decimal
(double) with Format: Currency symbol ($English (United States)), 2 Decimal
places, and Use a digit grouping symbol like this ($1,234.12). It shows up in
my document library column as “1500.0”
So, when this field is not blank, I have it automatically
copy itself to 2 other text fields where I do a lot of manipulation by
determining how many characters are in this piece of text, adding “00” if the
users just typed 500, for example, and add a dollar sign so the number displays
with a $ in the document library.
With all I do, I get these results for my 1 original field
and 3 manipulated/concatenated fields:
TB Bill Amount Text: 1500.0
TB Bill Amount 4 Email: $1500.0
TB Bill Amount Text TEST: 1,500
TB Bill Amount 4 Email TEST: $1500.0
Any suggestions on getting a dollar amount to display as a 2-decimal
dollar amount, even when the cents are “00”?