using treater than and replacing numbers

M

mja

I have a colum of numbers. I would like to find all of the numbers that are
greater than $36,000.00 and replace that numberwith $36,000.00.
 
B

bj

if the column with data is column a you could insert a new column b
and enter in b1
=min(a1,36000)
copy downto the end of the column.
you could then copy column b
and paste values onto column a
and then delete column b.
all you would need to do then is set thre format.
 
Top