How do I customize the number formats in Excel 2007? To custom your number formats you can simply right click and range of cells to Format Cells, then click Number tab and choose Custom. In our Excel 2007 training video we show you how to customize the number format to include any number of formats including: extra characters, colors and breaking down the most complex number format available in Excel 2007 in the Custom formats section. We show you how to identify the positive and negative number formats, zeros and text where you can set what text you want to always display. Once you've learned the format you'll be able to breeze through your own custom formats!

Purchase the training video and you can see this in action for yourself!