Edit formula over a range
 

I have a formula that extends over a large range.
A1 A2
=ROUND(forecast!X3*$Q8,0) =ROUND(forecast!Y3*$Q8,0)

How do I modify the entire range so that it no longer rounds without
completely running a new formula.

Thank ou


--
Nate

Edit formula over a range
 

Highlight column A and do CTRL-H (Find and Replace) as follows:

Find What: ,0)
Replace With: ,10)
then click Replace All

This will round to 10 decimal places, but that should be sufficient to
appear like no rounding.

Hope this helps.

Pete

On May 5, 12:53*am, Nate wrote:
I have a formula that extends over a large range.
A1 * * * * * * * * * * * * * * * * * * * * * *A2
=ROUND(forecast!X3*$Q8,0) * * * =ROUND(forecast!Y3*$Q8,0)

How do I modify the entire range so that it no longer rounds without
completely running a new formula.

Thank ou

--
Nate