elgringo56
Well-known Member
- Joined
- Apr 15, 2002
- Messages
- 869
This is probably a little problem.
Cell A1 contains a Blank. Cell A5 contains a formula, =A1. I select cell A5. I then do a copy. I then select cell A7 and do a paste special, values only. Cell A7 ends up a 0 (zero) instead of a blank. This is causing me a real headache with a large field of blanks and data that I am trying to move and then sort. Blanks will sort at the end of a list, Zeros will sort at the beginning of a list. How can I make the paste operation enter a blank when the initial cell was a blank?
Cell A1 contains a Blank. Cell A5 contains a formula, =A1. I select cell A5. I then do a copy. I then select cell A7 and do a paste special, values only. Cell A7 ends up a 0 (zero) instead of a blank. This is causing me a real headache with a large field of blanks and data that I am trying to move and then sort. Blanks will sort at the end of a list, Zeros will sort at the beginning of a list. How can I make the paste operation enter a blank when the initial cell was a blank?