Menu
Go to Apple's System Preference Language and Region. And change your Region to the United States. This will convert all currency to US dollars so click the Advanced button and set the Currency to British Pounds. Also change the Measurement Units. Click Ok and you're back on the first window.
You might need to change the default language to British English, mine didn't auto adjust from English when I changed the region, but I'm wondering how that impacts the proofing language defaults in Word. So it's something to keep an eye on.
Q How do you format negative numbers, including percentages, to show as red in Excel? A There are a couple of possibilities, but your best option is to use Conditional Formatting.In Excel 2003, begin by selecting the cells you want to format. Then select Conditional Formatting from the Format menu (see screenshot below). Excel then displays the Conditional Formatting dialog box.
Written by Jane Hames Turn a positive number into a negative in Excel using Paste Special During Excel training last week, I was asked how to turn a positive into a negative in Excel. The Excel user was calculating balances but the expenses came in form Sage as positive values, whereas they needed to be negative values. The ABS function can be used to turn a negative into a positive. To turn a positive into a negative you can use Paste Special.
This is what we did:. Starting with a sheet laid out a bit like this example, type -1 (in yellow here) somewhere on the sheet. This -1 will be used to multiply our positive numbers by minus 1. Highlight the cell with -1 in it. Select copy.
Highlight the cells to be changed into negative values. (You should still have the dotted outline showing around the -1 cell to indicate that this cell has been copied.). Select Paste Special from the arrow on the Paste button on the Home tab.
From the Paste Special box, select Multiply, then click on OK. Your positive numbers are now negative. I finished this off by calculating the sum of my incomings and outgoings to give me the balance. Excel training is the most commonly requested subject at Glide Training. We have helped hundreds of people to become more efficient and to enjoy their Excel use.