Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Turning negative to positive on a mass scale

 
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Word 2007 Crashes when Saving Files  
Author Message
Henry Stock

External


Since: Jan 17, 2010
Posts: 2



(Msg. 1) Posted: Sun Jan 17, 2010 4:11 pm
Post subject: Turning negative to positive on a mass scale
Archived from groups: microsoft>public>excel (more info?)

I am currently working with data that I exported from Intuit Quicken to
Excel. I was using a budget report that show all cash outflows as
negative numbers.

But I want to show these as positive numbers. I was wondering if there
were some technique for turning negative numbers into their positive
equivalents using a search and replace or any other technique that would
not involve individually changing each cell.

 >> Stay informed about: Turning negative to positive on a mass scale 
Back to top
Login to vote
Pete_UK

External


Since: Dec 4, 2008
Posts: 17



(Msg. 2) Posted: Sun Jan 17, 2010 4:11 pm
Post subject: Re: Turning negative to positive on a mass scale
Archived from groups: per prev. post (more info?)

If you multiply each cell by -1 it will change negative numbers to
positive (and positive to negative). To do this in one operation,
enter -1 into a blank cell somewhere. Select that cell and click
wrote:
> I am currently working with data that I exported from Intuit Quicken to
> Excel.  I was using a budget report that show all cash outflows as
> negative numbers.
>
> But I want to show these as positive numbers.  I was wondering if there
> were some technique for turning negative numbers into their positive
> equivalents using a search and replace or any other technique that would
> not involve individually changing each cell.

 >> Stay informed about: Turning negative to positive on a mass scale 
Back to top
Login to vote
Pete_UK

External


Since: Dec 4, 2008
Posts: 17



(Msg. 3) Posted: Sun Jan 17, 2010 4:11 pm
Post subject: Re: Turning negative to positive on a mass scale
Archived from groups: per prev. post (more info?)

You're welcome - thanks for feeding back.

Pete

On Jan 17, 9:36 pm, "Henry Stock" wrote:
> Thanks.
>
> "Pete_UK" wrote in message
>

> If you multiply each cell by -1 it will change negative numbers to
> positive (and positive to negative). To do this in one operation,
> enter -1 into a blank cell somewhere. Select that cell and click
> wrote:
>
>
>
> > I am currently working with data that I exported from Intuit Quicken
> > to
> > Excel. I was using a budget report that show all cash outflows as
> > negative numbers.
>
> > But I want to show these as positive numbers. I was wondering if there
> > were some technique for turning negative numbers into their positive
> > equivalents using a search and replace or any other technique that
> > would
> > not involve individually changing each cell.- Hide quoted text -
>
> - Show quoted text -
 >> Stay informed about: Turning negative to positive on a mass scale 
Back to top
Login to vote
Henry Stock

External


Since: Jan 17, 2010
Posts: 2



(Msg. 4) Posted: Sun Jan 17, 2010 4:36 pm
Post subject: Re: Turning negative to positive on a mass scale
Archived from groups: per prev. post (more info?)

Thanks.

"Pete_UK" wrote in message

If you multiply each cell by -1 it will change negative numbers to
positive (and positive to negative). To do this in one operation,
enter -1 into a blank cell somewhere. Select that cell and click
wrote:
> I am currently working with data that I exported from Intuit Quicken
> to
> Excel. I was using a budget report that show all cash outflows as
> negative numbers.
>
> But I want to show these as positive numbers. I was wondering if there
> were some technique for turning negative numbers into their positive
> equivalents using a search and replace or any other technique that
> would
> not involve individually changing each cell.
 >> Stay informed about: Turning negative to positive on a mass scale 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Colouring any cell in worksheet with negative value - Hi all, I have written the below code for making the cells from column to A to BB fill with red colour, if they have a negative value in them. I can't seem to make it work.....Any help will be appreciated! Thanks very much! Shivam ..

INDEX MATCH HELL ooops.. I mean HELP! - I know (or at least I think I do) that I can do this with INDEX MATCH. Here is what I want to do. I want to place this formula in cell C4 of Sheet 1. What I want this formula to do is to match the value of B2 of Sheet 1 with a list that is in Sheet 2...

Notation Bugs - Did anybody notice that Excel handles math notations (symbols) in an incorrect way? Try this: write -2 in cell A1. Write =1-A1^2 in a different cell. Write =-A1^2+1 in another cell. The two expressions are equivalent, shouldn't they? Well, the former..

How to create a single line separated by commas from a mat.. - Hello, I've the following problem. I've a table made of several columns. Each colum represents a characteristic regarding to a subject (e.g. Name, Surname, Home Street, etc...). In the rows I put the different people. I need to export these info to a....

Excel password Recovery - Hi All, i forgot my excel password, can any tell me how to recover the password there is any free tool is avail in web, Regards, Deen
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]