Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 12th 06, 02:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
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

  #2   Report Post  
Old September 12th 06, 02:14 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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   Report Post  
Old September 12th 06, 02:16 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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   Report Post  
Old September 12th 06, 02:17 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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   Report Post  
Old September 12th 06, 06:35 PM posted to microsoft.public.excel.worksheet.functions
lk lk is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 01:10 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017