Format cells to change a number from a positive to negative

I would like to be able to change a positive number to a negative number and
vice versa by formatting the cell.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Hi Jagfan,

I didn't understand it fully. Do you mean when you format a cell, say
making it bold, and it makes the positive number negative and vice
versa?

thanks,

Shail


jagfan123456 wrote:
> I would like to be able to change a positive number to a negative number and
> vice versa by formatting the cell.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...et.f unctions

=A1*-1

"jagfan123456" wrote:

> I would like to be able to change a positive number to a negative number and
> vice versa by formatting the cell.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...et.f unctions

Formatting does not change the value in a cell, merely how it looks.

However, you can achieve what you are trying to do by entering -1 into
a blank cell. Select that cell and click <copy> then highlight all the
cells you wish to change and click Edit | Paste Special | Multiply
(check) then OK and <Esc>.

Hope this helps.

Pete

jagfan123456 wrote:
> I would like to be able to change a positive number to a negative number and
> vice versa by formatting the cell.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...et.f unctions

Go to: Format, Cells, Category Custom find a format mask that looks like
what you want. The first format is for positive numbers, the second for
negative. Switch the format for positive and negative numbers. Play around
with them until you find what you want. For more choices, type "custom
number formats" into Help.

"jagfan123456" wrote:

> I would like to be able to change a positive number to a negative number and
> vice versa by formatting the cell.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...et.f unctions