In cell A1 I have the number 19.226
In cell B1 I have the number 18.981
In cell A7 I havewhich returns ELEV: 19.2FT="ELEV: "&ROUND(A1,1)&"FT"
In cell B7 I havewhich returns ELEV: 19FT="ELEV: "&ROUND(B1,1)&"FT"
I need to find a way to force B7 to report to one decimal place without truncating.
Any help will be greatly appreciated.
Bookmarks