View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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??