Quote:
Originally Posted by Pecoflyer
What happens if you try the following :
select the range to be copied
put the arrow against the upper border of the selected range it becomes a cross
while holding down your right mouse button you can then move this range to another place on the sheet
when you let the button go, a menu will pop up
click " copy here as values only" and see if that's OK
|
Still getting the decimal places that were removed with the conditional formatting
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
|
I've been testing this on my PC, when I have time, I'll try some of these variations on the Mac, where the copying and pasting will actually be done, but I don't expect to see any difference from the PC version.