I need the product of a formula in dollars.

[Guest]

In Excel 2003 I've assigned a formula to figure the sales tax on the sub
total. I type the percentage as a decimal (=E$4*.0562) and the product is a
number with 3 or 4 places to the right of the decimal instead of 2. How can
I get a dollar amount?

 

[Joseph Meehan]

In Excel 2003 I've assigned a formula to figure the sales tax on the
sub total. I type the percentage as a decimal (=E$4*.0562) and the
product is a number with 3 or 4 places to the right of the decimal
instead of 2. How can I get a dollar amount?

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.