View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S Davis S Davis is offline
external usenet poster
 
Posts: 138
Default I type in a cell,it is giving me the ##### instead of $10.99 why

....

Im guessing you may have to double clikc the cell boundary at the top
of the sheet. If its in cell A for instance, double click the line
between 'A' and 'B'

Otherwise, right click the cell, go to Number, and select Currency.
mizfroggie wrote:
When I type in $10.99 in a cell I am getting ##### instead of the $10.99. I
can't seem to find a way to change that. What do I have to do to get the
$10.99 into that cell?