View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
[email protected] patele@gmail.com is offline
external usenet poster
 
Posts: 2
Default Numbers appear as ##### instead of the actual number, how to fix?

Normally adjusting the column width should fix that.

ws65swc wrote:
Some of my stydents have entered numbers into cells or done a summation of a
series of cells and they get ###### signs in place of the actual
number...when mousing over the cell with the ###### a fly out appears with
the actual number. How do we make the ###### signs appear as the actual
number?