Better off fixing the problem at the source.

Biff

"Teethless mama" wrote in message
...
This formula converts text value to value

=PRODUCT(--A1,--B1)


"Free Ishii" wrote:

We are trying to do a simple <=PRODUCT function where we multiply two
cells:
the first cell is a number generated by an <=IF function, and the second
is
simply a cell with a single digit number. The result only shows the
single
digit number, viz 4*3=3. Any ideas?