AVERAGE & STDEV not formatting correctly across sheets

New Contributor



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 Replies
best response confirmed by nagol9109 (New Contributor)


Use the TEXT() function.

TEXT() formats numbers.


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