Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cells not showing all the text Jorge E. Jaramillo Excel Discussion (Misc queries) 3 October 7th 09 09:21 PM
Values in cells not showing Brennan Excel Discussion (Misc queries) 3 July 1st 09 09:34 PM
When I open Excell, my spreadsheet is not showing..? LynnIowa Excel Discussion (Misc queries) 2 June 2nd 09 06:26 PM
How can I only the cells showing by a filter? Ping New Users to Excel 1 December 19th 07 10:37 PM
Showing Updated Cells [email protected] Excel Discussion (Misc queries) 0 June 22nd 06 08:49 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"