Thanks for your response. I am aware that the formatting only changes the display, not the underlying value. What I'm trying to do is copy the formatted value (not the actual value), which works for the formatting applied to the cells. A cell has the value .6275 and is formatted to 2 decimals, displays in the spreadsheet as .63 and when copied the pasted value is also .63.

The problem is that I have conditional formatting applied to override this formatting for cells with a certain value. The formula I am using is:

The formatting applied to those cells is zero decimal places. And this works properly to remove the decimal from values that are 2 digits (>= 10) and the decimal value is 0. A cell with the value of 12.0 will display as 12 in the cell, but when copied, the pasted value is still 12.0, which is how the cells are formatted.

It looks like my only solution is to copy the cells into another temporary spreadsheet, and using Paste Special, paste only the values. This does seem to include the conditional formatting (e.g. 12.0 becomes 12). This is an extra step that I was hoping to avoid, although I should be able to script this at some point.