Excel Tutorial - Formatting I/C Number

 

This is tutorial formatting I/C in Excel.

When you enter an I/C number, you can just enter all numbers, and have Excel to put in the "-" (dash) for you automatically.

 

1. In cell B3, enter the I/C number without "-" (dash). i.e 481208051208

 

Excel Tutorial - Formatting I/C Number | Cemtech Training Center Puchong Selangor, Melaka

 

2.  Select cell B3, on Home tab, in Font panel, click on Format Cells dialog box launcher.

 

Excel Tutorial - Formatting I/C Number | Cemtech Training Center Puchong Selangor, Melaka

 

3.  In the Format Cells dialog box, do the following:

  • Click on the Number tab,
  • Under Category, select Custom
  • In the Type text box, enter ######-##-####
 
Excel Tutorial - Formatting I/C Number | Cemtech Training Center Puchong Selangor, Melaka
 
 
 

4.  Cell the I/C number in cell B3 is now formatted as 481208-05-1208

 

Excel Tutorial - Formatting I/C Number | Cemtech Training Center Puchong Selangor, Melaka

 

5.  To have the same format apply to other cells such as B4 and B5, you may use the Format Painter tool. Select cell B3 and click once on the Format Painter.

 

 Excel Tutorial - Formatting I/C Number | Cemtech Training Center Puchong Selangor, Melaka

 

6.  The mouse pointer changes to Excel Tutorial - Formatting I/C Number  . With this mouse pointer click on cell B4 and drag to cell B5

 

Excel Tutorial - Formatting I/C Number | Cemtech Training Center Puchong Selangor, Melaka

 

7.  Let’s enter another I/C number in cell B4. Remember just number, without dash “-“.

 

Excel Tutorial - Formatting I/C Number | Cemtech Training Center Puchong Selangor, Melaka

 

8.  Then press Enter. You will see that the I/C number is now formatted with the same format as in B3.

 

Excel Tutorial - Formatting I/C Number | Cemtech Training Center Puchong Selangor, Melaka

By Bee Bee Ong 

 

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
64-2, Jalan Puteri 2/2, Bandar Puteri Puchong, 47100 Puchong Selangor, Malaysia. Tel: 603-80684461
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka. Tel: 606-2835955