How do change the decimal in a formula?

  • Thread starter Thread starter NeverBoring
  • Start date Start date
N

NeverBoring

I am attempting to place text and a formula in the same cell. Everything is
fine, except the Average function is furnishing a long decimal string. What
I cannot do is correct this situation to have no decimal. I have tried the
format section and set the decimal to 0, but this is what I see.

FORMULA. ="Average "&AVERAGE(B4:B82)
CELL RESULTS. Average 119.982142857143

I wish it would read Average 119
Thank you.
 
Your post has ended up on an Access site that is not the best place for
answers to Excel questions. I would search for a Int or Round function and
enclose youe Average function in that.

Rod
 
I am attempting to place text and a formula in the same cell. Everything is
fine, except the Average function is furnishing a long decimal string. What
I cannot do is correct this situation to have no decimal. I have tried the
format section and set the decimal to 0, but this is what I see.

FORMULA. ="Average "&AVERAGE(B4:B82)
CELL RESULTS. Average 119.982142857143

I wish it would read Average 119
Thank you.
Click to expand...

Please post this Excel question in an Excel newsgroup. The webpage can be
confusing; the first group alphabetically is for Microsoft Access. Please
scroll down and find one for Excel.

John W. Vinson [MVP]
 
NeverBoring said:
I am attempting to place text and a formula in the same cell. Everything
is
fine, except the Average function is furnishing a long decimal string.
What
I cannot do is correct this situation to have no decimal. I have tried
the
format section and set the decimal to 0, but this is what I see.

FORMULA. ="Average "&AVERAGE(B4:B82)
CELL RESULTS. Average 119.982142857143

I wish it would read Average 119
Thank you.
Click to expand...
 
Thank you all for your help, especially, Brian. The formula is perfect.
NeverBoring
 
Back
Top