Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2017, 12:54 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Copying values that have conditional formatting applied Windows 7 64bit Copying values that have conditional formatting applied Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default


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
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 01-27-2017, 06:17 AM
Cosmo Cosmo is offline Copying values that have conditional formatting applied Windows Vista Copying values that have conditional formatting applied Office 2007
Competent Performer
Copying values that have conditional formatting applied
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
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.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Multiple Or Values Phil H Excel 4 05-21-2015 04:16 AM
Conditional Formatting for values with more than 2 decimals lynchbro Excel 6 04-17-2015 06:05 AM
Copying values that have conditional formatting applied Copying Conditional Formating lynette Excel 2 03-06-2015 11:53 AM
Copying values that have conditional formatting applied Copying and pasting values with unequal data columns grexcelman Excel Programming 5 12-05-2014 11:36 AM
Copying values that have conditional formatting applied Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft