Curiously, when I try the ISTEXT(A1) test, I get TRUE, but when I go to
"Format Cells" for A1, it shows that it is in Currency format. Why?

"Stephen" wrote:

"sorrywm" wrote in message
...
I am trying to convert a value in BHD to $. I have the amount in Currency,
BHD, in A1, and I have the type set as Currency, $ in A2. I am typing this
formula into A2: =A1*2.65. But I get ##VALUE!##, instead of an amount. Why
can I not multiply with currency?

*VALUE! indicates that the contents of A1 are not in the expected format. In
other words, A1 contains something other than a numerical value. My guess is
that it's text. You can test for this by putting the formula
=ISTEXT(A1)
into a spare cell.

You can only multiply by 2.65 if you start with a number. Maybe you imported
the data in A1 and it's ended up in text format? You should understand there
is an essential difference between a number displayed as currency (where the
currency symbol is merely part of the display, not the underlying data) and
a text string containing letters or symbols and numeric characters.