View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lewis Clark
 
Posts: n/a
Default Why is that happen ?

Try making the column wide enough to display all of the digits.

--

"0xC00D11CD" wrote in message ...
Hi,
i format all cells in D,E,F and G to currency and try to typ for example
1459.70 in cell D but it returns just this ########.
Can someone tell me why ?
Thank you in advance
Unal