How do I Limit decimal places in a string cell reference

O

Ozinus

I am referencing a cell which has 1 decimal place yet it shows about 12
places right of the decimal in the string. What am I doing wrong?
 
P

Pete_UK

Use this:

=TEXT(A1,"0.0")

or something like this:

="Result is: "&TEXT(A1,"0.0")

Hope this helps.

Pete
 
J

JBeaucaire

The cell DOING the referencing isn't formatted properly.

CTRL+1 will open the format box.

You need to be careful with references, your problem shows how data can
LOOK one way but actually be another. The cell you're referencing
appears to have a long calculated value in it with many decimal places.
It is formatted to only show 1 decimal place...which is usually OK.

But if you start doing calculations against that cell, you'll start to
notice discrepancies in the resulting math. That's because the number is
really much longer than you're seeing.

To eliminate the discrepancy, you need to round off those values
properly. Look at the help files on ROUND and MROUND. You can do the
rounding in the cell itself or in the cells that reference that cell,
just remember to do it.
 
B

Bernard Liengme

Either
a) format the cell to display only 1 decimal place
or
b) use a formula such as =ROUND(A1,1) to round the actual stored value to
one decimal place
best wishes
 
Top