close

I'd like to change from positive to negative numbers

In an un-used cell enter -1
copy that cell
select the cells you wish to invert
pull-down:

Edit gt; PasteSpecial... gt; check the multiply box

quot;byron mirandaquot; wrote:

gt; I'd like to change from positive to negative numbers

Depending on what exactly you want there are several things you can do.
If you want to have it on a differen cell you can use a formula in a
separate column, like:
=-A1
If you want to replace on the cell, you can enter quot;-1quot; in a separate cell,
copy that cell, select the cell(s) you want to change, and go to Edit -gt;
Paste Especial -gt; Multiply.
You can even make possitive numbers to look as negative, while still being
possitive, applying a custom format like -#;# I wouldn't recommend doing
this.

Hope this helps,
Miguel.

quot;byron mirandaquot; wrote:

gt; I'd like to change from positive to negative numbers

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()