How do I Limit decimal places in a string cell reference

[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?

 

[Pete_UK]

Use this:

=TEXT(A1,"0.0")

or something like this:

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

Hope this helps.

Pete

 

[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

 

[barry houdini]

Another way is to use FIXED function, i.e.

=FIXED(A1,1)