ExcelBanter - how to change the state of a number in a cell from negative to po.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to change the state of a number in a cell from negative to po. (https://www.excelbanter.com/excel-discussion-misc-queries/738-how-change-state-number-cell-negative-po.html)

Steve11

how to change the state of a number in a cell from negative to po.

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

Frank Kabel

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

All times are GMT +1. The time now is 04:32 AM.