Problem wih excel sheet

virenp

Hi Experts,
I am transfering data through a dataport to an excel sheet(.csv)
All the data are getting transfered properly except for an account no. field.

For eg.
If am account number is 0612 then my excel sheet data is 612.

how to get the correct account no.


Thanks,
Viren

mohana_cse06

Convert it into text and then export..
Search the forum, this topic has been discussed earlier.

virenp

Thanks Mohana for your reply,But

as said by you i converted it into text variable as ''''+(accvariable).The output of the same in my csv file is '0612 where the single quote( ' ) comes before 0612.I want to eliminate that single quote.
Thanks,
Viren