Formatting Numberby: Engr. Esmeraldo T. Guimbarda Jr.

There are a lot of options when formatting numbers. You can see the options on the tool bar. Go to Home > Number. There is a drop down menu which has a default option of “General”. You can change this to how you wish your numbers to appear. This option includes General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific and Text.

General has no specific format. This displays the original number that you have inputted.

Number will add 2 decimal places.

Currency will add a default dollar sign on the left side of the number.

Accounting will combine the number and currency format wherein it will add a default dollar sign and a default of 2 decimal places.

If you want to change how many decimal places you want to place and the money symbol, you can do this by going to Home > Number > More Number Formats. Under the Number tab, there are options to choose from. Choose Accounting then adjust the decimal and symbol to which you wish to change.

Short Date will change the number you have inputted into a “mm/dd/yyyy” format.

Long Date will change the number you have inputted into a “days of the week, month day, year”. Example: Monday, January 12, 1900.

Time will change the number you have inputted into an “hours:min:sec AM/PM” format.

Percentage will add two more zeros after the number, and two decimal places. And a percent (%) sign.

Fraction will make your number into a fraction format. This will only be visible if the number you inputted is a decimal. If it is not a decimal, it will just display the same. The number is made as a fraction by putting the “over 1” but, it is made invisible. For example, input 1.5 on cell A1. It will then be changed into 1 1/2 .

Scientific will make the number in a format that looks like a scientific formula or the one’s that you can see in a calculator.

Text will consider the number that you have inputted into a text. You can see that it will be aligned left just like texts.

Activity:

1. Open Microsoft Excel. Click on Start ► All Programs ► Microsoft Office ► Microsoft Excel or double-click on the Microsoft Excel shortcut on the desktop. This will open a blank workbook in Microsoft Excel.

2. Add contents to cells Click on cell A1 and type in “List of Expenses”. Input the items listed below. Left column A3 to A22. Right column B3 to B22. [Notebook][250], [Pen][200], [Stapler][180], [Paper clips][100], [Paper][355], [Chair][900], [Desk][1500], [Drawer][860], [Gasoline][2500], [Water][5003], [Food][7200], [Phone Service][995], [Rent][15000], [Employee Salary][50100], [Electricity][27800], [Repair Services][14539], [Internet][999], [Insurance][5000], [Maintenance][31270], [Property Tax][29068]

3. Format numbers Highlight cells B3 to B22. Do this by clicking and dragging from cell B3 up to cell B22. Release when done.

4. After highlighting, go to Home > Number > More Number Formats.

5. Under Number tab, Choose Currency. Then, choose 2 for Decimal Places option. And for the symbol dropdown, Choose PHP. Click OK when done.

5. Under Number tab, Choose Currency. Then, choose 2 for Decimal Places option. And for the symbol dropdown, Choose PHP. Click OK when done.

6. To save the document, go to File then click Save As Upon clicking Save, the Save As window will show. Locate where you want to save your file then type the name of file in the File Name box. Click Save. Your file is now saved.

Note: Save to Desktop and save as FormatingNumber as filename