View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KU KU is offline
external usenet poster
 
Posts: 1
Default 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