How to insert zero while writing data to excel sheet

chrisjones · Post by **chrisjones** » Thu Nov 30, 2006 1:20 pm

Hi Friends,
How to insert zero valuees while writing data to excel sheet using DataStage

Ex:
input: output
------- ----------
00004545--->00004545
I want the data in this format but by default it is removing zerso ,so please help how to insert zero values into Excel sheet.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 30, 2006 1:32 pm

Either write it as VarChar or do nothing and change the cell format within Excel.