I need to round numbers in my column, but can't find a formula or custom format that works. Please help.
Example:
###+##.## i need this rounded to ###+##.#
Sometime its just ##+##.## needing to be ##+##.#
Thanks!
I need to round numbers in my column, but can't find a formula or custom format that works. Please help.
Example:
###+##.## i need this rounded to ###+##.#
Sometime its just ##+##.## needing to be ##+##.#
Thanks!
Try
=ROUND(ref1+ref2,1)
I tried this, but it didn't do what I wanted.
I am entering stationing so I have 13+34.89 (13 is a distance marking the location of something and the 34.89 is additional distance added) i don't want to add those two numbers, I want them to remain as 13+34.89 but round .89 to.9.
Example of my table:
Doc1.pdf
Put the + part in a separate column and round in the usual way.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks