ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using Excell , have ######### showing up in the cells. Why (https://www.excelbanter.com/excel-worksheet-functions/257449-using-excell-have-showing-up-cells-why.html)

Capt. Seaweed

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!

Fred Smith[_4_]

Using Excell , have ######### showing up in the cells. Why
 
Your column is not wide enough to display the result. Widen it or use a
smaller font.

Regards,
Fred

"Capt. Seaweed" <Capt. wrote in message
...
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!




All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com