| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste + erasing date
HI guys, I have two questions
When pasting, how do you invert data you have copied in the one cell without affecting other cells, eg I copied 800 594 1002 754 410 But I want to paste it as 410 754 1002 594 800 Question 2 I have data 10/23/07, 100 10/24/07, 115 10/25/07, 99 The data is connected when I paste it, but all I want are the numbers 100 115 99 How can I remove the date in front? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date changes from copy to paste | Excel Discussion (Misc queries) | |||
| How do I copy borders without erasing other destination formats? | Excel Discussion (Misc queries) | |||
| date copy paste should be very easy | Excel Discussion (Misc queries) | |||
| Copy and Paste Date - weird behavior | Excel Discussion (Misc queries) | |||
| Date copy, Paste error | Excel Discussion (Misc queries) | |||
Threaded Mode
