Truncate leading zeros in exported excel file from BaaN
We are havin a session to export some data from baan to excel. There is a string field of length 3 called "Revision Number" in our report. The excel file is delimited by pipe (|) symbol. When we delimit (text to column) this file the leading zeros of field "Revision Number" gets truncated. We want the record in excel must be as it is in baan table.
Example: Revision No. in BaaN table is 001, 010 etc. but in excel it's showing as 1, 10 respectively. We want the output as 001, 010 in excel.
Quick response would be appreciated.
* You are the only one who can use your ability. It is an awesome responsibility *