Prev: Losing rows that reference data from another worsheet
Next: Copying Conditional Formating to another worksheet
From: Capt. Seaweed Capt. on 25 Feb 2010 20:01 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!
From: Fred Smith on 25 Feb 2010 20:10
Your column is not wide enough to display the result. Widen it or use a smaller font. Regards, Fred "Capt. Seaweed" <Capt. Seaweed(a)discussions.microsoft.com> wrote in message news:55544124-D2F6-4DB6-B206-4F1688F45D75(a)microsoft.com... >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! |