I have a set of numbers from A1:A10. In cell A12 my formula is
=trend(A1:A10) and get an answer of 5.145454545, I format column A for
number with no decimal places. If I copy and special past (value) to
cell A15, It will show value of 5 in cell, but in formula bar it still
show's value of 5.145454545?? How do I get it so it show's a value of
5 in formula bar instead of 5.145454545?

On Sun, 15 Jan 2012 12:27:42 -0800 (PST), JAgger1 wrote:

I have a set of numbers from A1:A10. In cell A12 my formula is
=trend(A1:A10) and get an answer of 5.145454545, I format column A for
number with no decimal places. If I copy and special past (value) to
cell A15, It will show value of 5 in cell, but in formula bar it still
show's value of 5.145454545?? How do I get it so it show's a value of
5 in formula bar instead of 5.145454545?


=round(your_formula,0)

Or you could set Precision As Displayed in the Options, but this will irrevocably change the precision of all your cells.

On 16/01/2012 7:33 AM, Ron Rosenfeld wrote:
On Sun, 15 Jan 2012 12:27:42 -0800 (PST), wrote:

I have a set of numbers from A1:A10. In cell A12 my formula is
=trend(A1:A10) and get an answer of 5.145454545, I format column A for
number with no decimal places. If I copy and special past (value) to
cell A15, It will show value of 5 in cell, but in formula bar it still
show's value of 5.145454545?? How do I get it so it show's a value of
5 in formula bar instead of 5.145454545?


=round(your_formula,0)

Or you could set Precision As Displayed in the Options, but this will irrevocably change the precision of all your cells.

Like Ron said..

=ROUND(TREND(A1:A10),0)

Cheers
Mick