Replace number in formula by position?

  • Thread starter Thread starter Todd
  • Start date Start date
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
 
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
 
I don't think you'll find anything faster than Replace All (with your range
selected).
 
Back
Top