using treater than and replacing numbers

[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.

 

[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.