Oct 21, 2010 Using ABS() will return the absolute (positive) value of a number. Original values in column B. Formulas below in column C: =-B Positive values in B give negative values in C. Negative values in B give positive values in C. =-ABS(B) Both positive and negative values in B will result in negative values in C. ![]() ![]() I couldn't find an appropriate section for this question. Please forgive me if I posted it in the wrong place. I've been using Excel for Mac 2011 since it came out. Up until I updated to Yosemite, formatting negative numbers with parentheses appeared in the drop down menu, i.e., right click to get format cells, click 'number' tab on top, click 'number' on left. There is a dialog as to how you want negative numbers formatted. Parentheses used to be an option but no more. I attached a screen shot. Same issue here with Excel 2011, problem started with the Yosemite installation and was not fixed with 10.10.1 nor the latest Microsoft update. It's a big problem for accountants! On the Microsoft forum this gentleman replied with a workaround but it's a hassle to have to do this for each new spreadsheet. Replied on November 9, 2014 If you go to the dialog shown in Phillip's post and select 'Custom' on the left side, you can enter this to get the parenthesis back: $#,##0;[Red](-$#,##0) Or this to use square brackets: $#,##0;[Red]'['-$#,##0']' The format means use $#,##0 for positive numbers and use [-$#,##0] in red for negative numbers. You could remove the hyphen too and just do this: $#,##0;[Red]'['$#,##0']' I hope Apple takes note and pushes a fix for us. Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. Outlook for mac 15.33 mail could not be received at this time. All postings and use of the content on this site are subject to the.
0 Comments
Leave a Reply. |