Replace number in formula by position?

T

Todd

Hi.

I want to replace a number in a formula that rounds. The
formula changes from column to column but the position of
the charecter is always the same. Can I search the formula
by position and change rounding from 0 to 2 decimals?


=IF($U16="","",IF($U16>0,ROUND(D16*$U16,0),""))


Thanks,


Todd
 
T

Todd

Ohh,

I did the find and replace for just the last few numbers
in the formula. I was thinking it was harder than it is.

Thanks for the help!


Todd
 
D

Dave Peterson

I don't think you'll find anything faster than Replace All (with your range
selected).
 
Top