Working with currency and decimals

Given the form below, how can I show the Unit Price in currency format, but store the actual value in the database as a number:

The Extension is a calculation of the Unit Price * Quantity, so I can’t format it with the Currency formatter because that would be a text value and I think that would try to send the formatted value to the server anyway. Anyone know how to display it as currency but still retain the numeric value.

Community Page
Last updated: