format decimal length

[Brian P.]

Hi there -

I have a chart title linking to a cell that says:

="$5,000 invested annually @ " &average(U2:U40)

Is there a way to limit the decimal length to only two places here?
I've explored formatting and it's stuck at displaying 14 decimals.

Thanks - Brian

 

[joeu2004]

I have a chart title linking to a cell that says:
="$5,000 invested annually @ " &average(U2:U40)
Is there a way to limit the decimal length to only two places here?

 

[Brian P.]

Thank you, sir

- Show quoted text -