Apply To:
Microsoft Excel
Case:
* In Column " NUMBER_ID", must have a total digit is 16.
In file "Example Data.xls",
there is so much row that have invalid character at column “NUMBER_ID”.
There a problem when replace manually invalid character
is the format column become to Number, where we still want a text.
Untuk download file, silahkan klik link berikut ini:
* file "Example Data.xls"
yaitu
https://docs.google.com/open?id=0B6a5vK3IVP_0TTUxUzNQTzl1TTA
* file "How To Replace Much Invalid Character in Column with Format Number.pdf"
yaitu
https://docs.google.com/open?id=0B6a5vK3IVP_0UkNLOHhqM0ItM3c