ExcelBanter

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 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com