View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default what does ## mean?

The column might not be wide enough. Double-click the border in
between the column headers of your column and the one next to it. The
column should autofit to the widest value.


HTH,
JP

On Apr 2, 10:49*pm, Xipha wrote:
I have a formula calculating a value, but instead of showing the answer it
shows ## in the cell, however when you hold the mouse over the block the
correct number shows up in a little box. Does anyone know why this is
happening and how to fix it?