View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jezzica85
 
Posts: n/a
Default Replacing specific numbers

Hi all,
This is probably easy, but I can't figure it out--is there a formula I could
use to replace any number in a range that's greater than 1 with 1?
Thanks!
Jezzica85