Attached is a demo file, notice that all cells are formatted with the custom formatting '0.0#'.
The Conditional Formatting removes the decimals from any other values that are 10 or more, as you can see in the first column. If you clear the custom formatting, from the file then you'll see the values as 98.0.
When I copy the top row, it comes out as:
Quote:
|
96.0 8.1 11.3 7.3 7.6 96.0 6.8 6.8 5.5 1.1 12.0 6.0 0.63
|
What I'm looking for is:
Quote:
|
96 8.1 11.3 7.3 7.6 96 6.8 6.8 5.5 1.1 12 6 0.63
|
While doing this, I found that the 'Paste Special' looks like it uses the actual value which has 4 decimal places for the last cell, so it comes out as
Quote:
|
96 8.1 11.3 7.3 7.6 96 6.8 6.8 5.5 1.1 12 6 0.6278
|
So, using the 'Paste Special' might not be the answer I'm looking for after all. I may have to come up with a scripted solution unless there's a way to do this otherwise. I've tried several of the options in the 'Paste Special' dialog, and didn't notice any that gave me the result I need.