AVERAGE & STDEV not formatting correctly across sheets

[nagol9109]

Hello, 

I am having trouble getting AVERAGE and STDEV to format correctly. I am trying to get a summary page going for different samples of different water sources. I am referencing data from a different sheet, and I suspect that is where my issues are.

My code looks something like this:

=AVERAGE('Irrigation Water'!E:E)&" (+/- "&STDEV.P('Irrigation Water'!E:E)&")"

It is giving me correct values, but the numbers are returning like such:

7.16666666666667 (+/-2.60874597374975)

I would like them to just have two decimal places, but the formatting for the cell isn't changing it. I have the source and return cells all formatted as numbers with 2 decimal places, but it is coming out on it's own.

Any advice would be greatly appreciated.

[#2 · Accepted solution]

@nagol9109 

Use the TEXT() function.

TEXT() formats numbers.

[#3]

@Detlef Lewin Of course! Can't believe I didn't think of that sooner. Thank you so much.