| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste cells containing only numbers with .50 in it
=IF(D21-INT(D21)=0.5,D21,"")
If you truly want the numbers copied and pasted you would have to use VBA. Gord Dibben MS Excel MVP On Wed, 2 Jun 2010 07:39:01 -0700, HunterX wrote: I have been trying to come up with a formula that will read each cell in a column and copy & paste only the cells that contain numbers with .50. I can seem to properly configure the formula to read any whole number as long as it contains .50 in it. I want these vnumbers pasted into a seperate column. =IF(D21="*"+"0.50"),(D21),("") Thank you very much for your assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable copy and paste numbers to and from Calculator | Excel Discussion (Misc queries) | |||
| copy & paste numbers instead of formula | Excel Discussion (Misc queries) | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| How do i copy numbers from Web and paste to excel and and get tota | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Threaded Mode
