I know you use 'paste special' to just copy over the data with/without formatting. Is there a way to not have to even do this by forcing excel to automatically use certain formatting no matter what is done?

Also, I set up a formula to copy a value over from another column if the number matches. Here is the formula:

= IF(OR(F69=1800,F69=1200,F69=200) , F69, "" )

So if the number 1800, 1200, or 200 is placed in F69, it'll copy that value to whatever column I put this formula in. However, when the IF formula is satisfied and the number is copied into the column, the formatting defaults back to general.

I have cells set up to use the accounting format with 2 decimal spaces. Is there a way to force excel to keep this format? Or, at least, is there a way to include a format in a formula so it doesn't default to general?