I don't have any decimals displayed...that shouldn't matter anyway. If I
have a number like 14,234.7, making it 14,234 isn't going to make it fit into
the cell any better, it will still be too big.

"Bernard Liengme" wrote:

Could you decrease the number of decimals displayed?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Stephen" wrote in message
...
I have a cell who's width is 2.43 and which contains a formula which
calculates any number of things, such as square feet, cubic feet, tons,
ect.
based on which measurements are given. My formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for general or
text, the cell displays pound signs instead of the number because the
number
is too large to fit into one cell. I'm using Excel 2000. Like I said,
I've
already tried formatting it for general, and for text, and neither worked.
Does anyone know how to get my spreadsheet to display numbers?