After registering Kookmin Bank passbook account for quick inquiry
Account transaction details through quick inquiry
How to organize by converting the transaction date to the transaction date after downloading Excel
The date and time of the transaction is wrapped, so it must be processed in the following way 국민은행 빠른조회
For the transaction date field, select -Format Cells-Align-Text Alignment > Horizontal-Normal., Vertical-Up.
Client/Recipient-Cell Format-Correct-Text Adjustment > ■ Enable text wrapping □ Uncheck the text wrapping check box to use it. 이베이스매뉴얼
1. Add 1 space between the date and time of the transaction
2. Enter the title of the transaction date in one additional column, =TEXT(LEFT(Transaction Date, 10),”yyyy-mm-dd”) Enter the formula in the first additional column and press Enter
If it is entered in the formula input cell box, it is automatically reflected up to the bottom
Managed as above
One
Then, copy the change in the transaction date to another Excel and paste the number.
0000.00.00 is displayed, and the pasted number is
Control+H > Find and Replace popup
what to find. enter a point
Replace with – Enter a minus
If you replace all, it will be processed as 0000-00-00
How to use Kookmin Bank Quick Inquiry
The Kookmin Bank quick inquiry service, which allows you to quickly check the balance of your KB Kookmin Bank account without logging in, can be used without logging in, so it can be useful when you do not have a joint certificate or financial certificate.
※ To inquire account balance and details without logging in, you must register for the quick inquiry service.
KB Kookmin Bank quick inquiry service account registration and inquiry method
About KB Kookmin Bank quick inquiry service account registration and inquiry method that allows non-login to inquire Kookmin Bank account without login
Let’s learn how to use it simply. If you go to the quick inquiry service page provided by KB Kookmin Bank, you will see the fields for account number, password, internet banking ID or business number as shown below. You can quickly search by entering all the relevant information and clicking the inquiry button.
Source: KB Kookmin Bank
In the inquiry result, you can see the total balance, withdrawable balance, and transaction history, and transaction history can be viewed at once for the last 6 months. You can also save it as Excel or print it out through the Print button.
Source: KB Kookmin Bank
※ If you want to check the account balance of all banks, please refer to the link.