View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Capt. Seaweed Capt. Seaweed is offline
external usenet poster
 
Posts: 1
Default Using Excell , have ######### showing up in the cells. Why

I have a quote form set up. Each line includes quantitiy, price and
extension. Extension is Q x P. When entering the price on a couple of cells
it shows multiple # signs yet still has the entered amount in the formula
block above. The extension is correct also but I need the price to show up
as the numerical number not a "#" sign. HELP!