View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try:
- put -1 in an empty cell an copy that cell
- select your numbers
- goto 'Edit - Paste Special' and choose 'Multiply'

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve11" schrieb im Newsbeitrag
...
What is the easiest way to change the gender of a number in a single

cell or
columns of cells or rows of cells in a Exel spreadsheet