Sunday, February 04, 2007

Entering 00

How to enter the value 00 in Excel?
How to precede a number with zeroes?
How to format numbers as text?

By default, you cannot enter the number 00 in Microsoft Excel. (If you don't believe it, try it). Neither you can precede a number with 0 (You cannot enter 070 in Excel)

To do this,

  • Right click and select Format cells (You can press CTRL+1)
  • Select the NUMBER TAB (By default, this should show up)
  • In the CATEGORY list, Select TEXT and click OK
Now you can enter 00 or 000 or precede any number with zero.

If you add two cells that contains numbers as text, it would add up. So you can have some cool calculations too.

No comments: