if you type out the $ sign and a numeral excel should interpret that as
currency and still come up witht he answer you want
--
paul

remove nospam for email addy!



"Bernard Liengme" wrote:

=A1*A2 will multiply the values in A1 by A2 regardless of the cells having
constants or formulas
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"sazza26" wrote in message
...
How do you multiply two cells together without having an error message
show
up? One cell has the amount shown in dollars, the other is just normal.
The
formula doesn't shows up with errors, but don't know what formula i should
use.