I only saw 1 or 2 decimal places in the 2nd column. That file and a new one was doing something that my other tests yesterday did not. After I set the formats, saved, closed, and opened, it rounded as I explained yesterday AND removed the NumberFormats. I would have expected that yesterday but it did not happen with your file. Tested on xl2010 xppro.

Howard, please test what was posted and play with it. If you can live with how it works, we can do what you originally asked.