excel for mac use parentheses for negative numbers

Excel Use Parentheses For Negative Numbers Series Can Not

Basically I want to identify the two values where it switches from positive to negative and also indentify the values where it goes negative to positive, I can then fit a straight line between them to find a better approximation of the intercept (though it might not be necessary).

Been trailing the net and this board but cant work out how to do a simple variance.

How do I work out the difference between two numbers - including negatives.

If the numbers are all positive, its fine as its simply a case of A - B C which is your difference.

I need a formula that would give the following: First Number Second Number Difference 1 5 4 1 -5 -6 -1 5 6 -1 -5 -4 -5 -1 4 Hopefully theres a simple function Ive been missing.

The Geomean function doesnt work because it only uses positive numbers.

Any help Right now, Im trying to accomplish this by making a conditional format.meaning when my cell equals less than -100 I make the cell color and font the same (so it looks blank, but its not).

On excel, if I divide 462,534.05 by 335 I get 1,380.70.

Then if I times 1,380.70 by 335 I get the SAME result of 462,534.05.

I have to account for the difference of not dividing equally so there is some format or accounting function thats preset that I dont want but I have no idea how to fix it or format my excel sheet to calculate as my calculator would.

When I open any spreadsheet (new or already populated) the black box that normally frames the active cell is missing (showing which cell you have selected).

Excel Use Parentheses For Negative Numbers Series Can Not

In addition: Can not fill series Can not change cell format (specifically to show Currency or Accounting w symbol) And I am sure there is much more that I have not found yet.

I have not seen a single thread on this topic anywhere on the internet.

Help.

I am working with an Excel spreadsheet and saving it as a.csv file in order to upload to an application that parses out the.csv data as transactions.

The system requires.csv files, so this is how I need to save my doc (with this extension).

I have been successful at preventing Excel from coverting that long number into scientific format.

I have saved as a TXT file, pasted the longer number and it displays correctly.

That is all good.

But I have to save as a.csv.

So if I do that, close the Excel window, and then open again (as the.csv file), the numbers are back to being displayed in scientific format.

I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file.

But again, the second I save as.csv, close the window and then open that file up again, that dang scientific format is back.

Does anyone have any idea of how to work around this Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to stick so that they dont revert back to scientific format when I reopen the file Thanks so much for your help.

Instead of the y axis being on the left hand side, i wish for it to cut at 0,0.

I have tried formatting both the axis and it would appear that the x axis already cuts the y axis in the right posistion so i need to format the x axis to make the y axis cut it at 0,0.

I have already tried typing in 0 instead of 1 and it keeps saying it need to be number more than or equal to 1.

I tried using the intercept function and swapping around the y values for the x values, but it only returns 1 value (so Id guess it uses a linear regression to estimate a single line through the axis).

I was thinking of trying a nested ifand statement but I havent quite figured out how to do it.

Excel For Mac Use Parentheses For Negative Numbers