Custom formats in Excel

Ok, so here's the scenario, you want to enter a value like 20Kg (or 44 lb) into an Excel cell. All goes well until you try to multiply the value. Instant disaster. Your number isn't a number it's a piece of text and you can't multiply or add text. You can't divide or minus text or find the 4th power of it either - you get the idea.. it's basically a useless entry - pretty but useless.

SO, how do you format a cell so it displays the Kg after the number but so it still treats the entry as a number? I'm so glad you asked!

The answer is to create a custom number format. Click the cell or a range of cells and choose Format > Cells > Number tab. Select the Custom entry and type something like 00.00 "kg" in the text box and click Ok. Now, enter the numbers again as 20 or 40 etc and the kg will appear automatically after the number courtesy of the format - and the number, well it's still a number so you can add, multiply, divide and do all sorts of other wonderful things to it as you like.

You can also add the text before a number. So, for all those lovely Canada dollars I get paid by the folk at Hub Digital Living where I write a monthly Office column, I type a Custom format like "CAN" 00.00 in my sheet where I record my payments. It's all so easly when you know how.. and now - you do too..

Formatting table cells in Word

Since Microsoft Word 2002, it has been possible to format a series of cells in a table all at the one time, even if they are not contiguous (a lovely word that means not side-by-side).

To do this, select the first cell then Control + click on the other cells that you want to share the same formatting. Once all the cells are selected you can apply a formatting such as a shading to those cells. Note, that the Shading button on the Tables and Borders toolbar in Word 2002/2003 is the one to use, the one on the Drawing toolbar is the Fill button - it looks the same but doesn't work the same!

Selecting and formatting non contiguous cells all at ones makes it a quicker process to format a table than it would be if you selected and formatted each cell individually.

However, of course, the F4 key still works in cells in a table so you can, for example, fill a cell with a shading color or a format option and then click in another cell and press the F4 key and have that format applied to this cell too. The F4 key is a repeat key which repeats the previous command and it's a great key to learn to use anytime you're working with Word.