A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Format cells to change a number from a positive to negative



 
 
Thread Tools Display Modes
  #1  
Old September 12th 06, 02:02 PM posted to microsoft.public.excel.worksheet.functions
jagfan123456
external usenet poster
 
Posts: 1
Default 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
Ads
  #2  
Old September 12th 06, 02:14 PM posted to microsoft.public.excel.worksheet.functions
shail
external usenet poster
 
Posts: 195
Default Format cells to change a number from a positive to negative

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


  #3  
Old September 12th 06, 02:16 PM posted to microsoft.public.excel.worksheet.functions
Nobody
external usenet poster
 
Posts: 47
Default Format cells to change a number from a positive to negative

=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

  #4  
Old September 12th 06, 02:17 PM posted to microsoft.public.excel.worksheet.functions
Pete_UK
external usenet poster
 
Posts: 8,856
Default Format cells to change a number from a positive to negative

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


  #5  
Old September 12th 06, 06:35 PM posted to microsoft.public.excel.worksheet.functions
lk
external usenet poster
 
Posts: 39
Default Format cells to change a number from a positive to negative

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
change 2000 cells (negative numbers) into positive numbers lisbern Excel Worksheet Functions 2 August 16th 06 05:54 PM
change number format gaj Excel Discussion (Misc queries) 1 June 19th 06 08:26 AM
Format cells (number) issue Amalthea Excel Discussion (Misc queries) 1 April 5th 06 01:07 PM
Force function to show positive or negative number? smoore Excel Worksheet Functions 3 March 3rd 06 08:34 PM
How to change a series of positive numbers to negative numbers Ellie Excel Worksheet Functions 5 September 5th 05 05:10 PM


All times are GMT +1. The time now is 02:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.