Generating Excel spread sheets from Sequel on the iseries
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.
Thanks
Software/Hardware used:
Software/Hardware used:
ASKED:
April 21, 2006 8:48 AM
UPDATED:
December 6, 2009 8:31 AM
RELATED QUESTIONS
Answer Wiki:
Try converting the number columns during the extract with the DIGITS function
SELECT digits(NUMBER_COLUMN) FROM MYLIB/MYFILE.
======================================================
If you want a character column to contain only numeric values, prepend the digits with a single quote:<pre>'013</pre>If you don't like how Excel works, don't use Excel. Wish there was a better answer.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
