Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 193
14 April 2007

Start each week with a free tip

To subscribe, please type your email address in the box below:

display your numbers with leading zeros (Microsoft Excel)

Full bragging rights for this week's tip go to Tan Razaq who was Thursday's hero at the Advanced Excel training session when he knew how to use a custom number format to display leading zeros.

Having explained how to create a custom number format if none of Excel's predefined formats are what you want (for instance, using the format code #,##;(###) to display negative numbers in brackets) one of his colleagues asked how to display a fixed-length number with seven digits.

Here's how:

  1. Right-click the cell and select Format Cells from the shortcut menu (or choose the Format, Cells command)
  2. Click the Number tab, if necessary
  3. Select the Custom option in the Category box
  4. In the Type box, type the custom format 0000000 (i.e. the same number of zeros as digits you want to display)
  5. Click OK

When you use this format, if you type 123 Excel will display 0000123. (Thanks for your help, Tan! It was good to have you there!)

Finally, there are still a few places left on the next hands off Excel seminar, planned for Monday, 30 April. So if you are looking to excel with Excel, but the very thought of spending a day in front of a computer in a classroom puts you off ... Or perhaps you don't want to spend time entering data, correcting mistakes and feel as if you are slowing everyone else down? Or perhaps you are happy to experiment on your own and don't want to wait for slower delegates to catch up? Then join me for a lively mix of demonstrations and business examples and go back with a seminar handout and CD packed with exercise files to practice what you've learnt at your own pace in your own time. You can book and pay (GBP247 only!) online; see http://www.roem.co.uk/excel_with_excel.html

Until next week.

Email this page to a friend

Enter recipient’s email address in the box below:

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
April 2007