Numbers exceed column width

  • Thread starter Thread starter rlconc
  • Start date Start date
R

rlconc

Hi friends,
Here's a silly question. Imagine it's compulsory for you to work with a
worksheet that has its columns width set to 2.
If you write the word "mortgage" in any cell , you'll see it completely.
But if you write 5555, all you'll see is ##. The real problem is if I do any
formula on other cell, I always see ## instead of the result.
How can I see all digits without changing columns width?
Thanx in advance
rlconc
 
Use the TEXT function with your formula, eg:-

=TEXT(B5*2000,"@")

This will ensure that the result of your formula is displayed whole, though it will be
text and not numeric.
 
No. You will actually see numbers, but they will just be in text format, so not
recognised as numbers by another formula for example. Depending on what formulas you have
referencing these though, there are ways round this.
 
Hmmm... fine
Let's do =TEXT(14.000;"@") in cell B11, =TEXT(100;"@") in cell B14 and
=TEXT(19;"@") in cell I5
If i do in cell P8 =$B$14*$I$5*(COLUMN(P7)-8)<$B$11 is says TRUE
when 100*19*8 = 15200 which is obviously NOT lesser than 14000, so the
result is FALSE.
That's why I needed numeric format
Anyway, thanx again!
 
As I said, there are ways round it:-

P8 =$B$14*$I$5*(COLUMN(P7)-8)<N($B$11)

or

P8 =$B$14*$I$5*(COLUMN(P7)-8)<--$B$11
 
Hi there,

'2' seems to be a ridiculously narrow width if you're keeping long numbers
in the cell, but that's just my two cents! You could always go to
Format-->Cells and on the alignment tab select "Shrink to Fit" although this
may make your numbers too small to read.

HTH,
katherine
 
Back
Top