OK. I give. What I want to display is a right justified, two decimal digit currency value with the $ sign always just to the left of the leftmost digit.
Using the "currency" format option for a numeric field gives me my floating $ but also yields 4 decimal places. Or, I can use a format template to get two places but then the $ doesn't float to the right place.
I see a message from January that indicates I must use a format template, but the message doesn't specify what the mask should be.
Should I use the currency option with a format template. If so, what does the template look like (assume I want to express up to 99,999.99 with commas).
Nothing I've tried works quite right. Help.
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum