The easiest thing to do is not use it as a formula, but set the cell
properties. On the tool bar, with the cell selected, you should see a
buttong to move the decimal place. Click it until it is what you need.

Why do it the hard way?

--
John C. Harris, MPA
JCZ Consulting Services, LLC

"badgercat" wrote in message
...

In cell C, I have a formula the divides cell A, by cell B. =sum(A1/B1)
this gives me a number with several decimal places. x.abcdefgh

I would like to be able to round this number to the nearest single digit.

I found the formula =round(C1,0). I'm pretty sure that's what I want.
I do not want to add another colume to my spreedsheet

How do I combine these two formulas into one cell?

Thanks in advance for your help
BadgerCat