format decimal length

  • Thread starter Thread starter Brian P.
  • Start date Start date
B

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
 
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?
Click to expand...
 
Back
Top