Starting over on Excel.
a. We want all numbers on a row to be displayed as $1.92 for positive numbers and ($1.92) for negative numbers. I look at currency and accounting and no $.
b. We want to highlight + and - currency amounts for 5 columns in a row and getting the summation of those 5.
We are not seeing "sum" bottom right. We see autosum top right but it gets us nothing but a flashing cell and did not add the 5 numbers. I used this years ago and having to put a + after every number was not required. With that choice we might as well scrap Excel and do the calculation from a calculator on Word or even a plain piece of paper.
c. In some cells laterally we have words. I want the word to be centered in the cell.
This is Office 2007. I don't see what you may see. Thanks.