Can Data from a calculated field be formatted as currency?
Example: I want to multiply Fields called Share Price (Currency) * Share (Number). When I do this in a query I get a number not formatted to look like currency, instead I get a number with many decimal places and no $ sign. I like to see the sum as currency with 2 decimal places. Is this possible.Thank you.
Example: I want to multiply Fields called Share Price (Currency) * Share (Number). When I do this in a query I get a number not formatted to look like currency, instead I get a number with many decimal places and no $ sign. I like to see the sum as currency with 2 decimal places. Is this possible.Thank you.