when i use =product(cell,multiplier), the box ... only shows ###
 

the box with the FX shows "###" insted of the actual numbers, currency that
the total should be displayed. if i highlight it, he total shows in a
seperate window, but the box displays ###. is this a security feature
designed to ruin my day or what??

when i use =product(cell,multiplier), the box ... only shows ###
 

First thing to try is to make the column wider,
OR
make the font size smaller.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"gogh" wrote in message
...
the box with the FX shows "###" insted of the actual numbers, currency
that
the total should be displayed. if i highlight it, he total shows in a
seperate window, but the box displays ###. is this a security feature
designed to ruin my day or what??