I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base.
The problem is when they enter 013, the spread sheet turns it into 13(blank). If I format the excell cell as text it will hold the leading zero.
Is there any way this cell can be formated when sequel creates the spread sheet.
April 21, 2006 8:48 AM
December 6, 2009 8:31 AM