How to Type ID Numbers in Excel Without Changing the Last Digits

Опубликовано: 13 Сентябрь 2026
на канале: Ignasius Ryan
229,158
5.2k

This video explains how to type your National Identification Number (NIK), Taxpayer Identification Number (NPWP), Family Card (KK) number, and other multi-digit data without changing it. Typically, the last digit can be changed to 0.

I'll explain it here.

EXERCISE FILE
⬇️ Free download here: https://docs.google.com/spreadsheets/...

EXCEL E-BOOK PRICE IS ANYTHING
🎓 Learn Excel from Scratch E-book https://lynk.id/ignasiusryan/D8p04vG
📊 72 Excel Formulas E-book https://lynk.id/ignasiusryan/kKgPP4W
🏎️ 100 Important Shortcuts E-book https://lynk.id/ignasiusryan/DAabpz5

MY DESK SETUP
🖥️ Monitor screen https://invol.co/cl8a7cu
⌨️ Keyboard https://invol.co/cl8a6w8
📷 Webcam https://invol.co/cl8a6y8
🖱️ Mouse https://invol.co/cl8a788
🎙️ Microphone https://invol.co/cl8a76o
💡 Lighting https://invol.co/cl8a75k
💼 Desk https://invol.co/cl8a7sj
🥙 Others https://ignasiusryan.notion.site/Desk...

GET IN TOUCH
📷 Instagram   / ignasiusryan  
✈️ Telegram https://t.me/ignasiusryan
📧 Email [email protected]
📽️ TikTok   / ignasiusryan  
🌐 Website linktr.ee/ignasiusryan

I use Excel 365.

If you found this video helpful, please subscribe so you don't miss my other videos and help share it with others. Who knows, this might be the video they've been looking for.

Thanks,
Igna

That's awesome, you read the video description all the way to the end.