05-13-2009 12:24 PM
Hi,
We are trying to export a 24digit Id which will be preceding by zero's into an excel sheet. But while exporting, the zero's are been excluded. Please let me know if you have come across such requirement.
Thanks.
05-13-2009 12:29 PM
05-13-2009 12:34 PM
Hi tejomayi,
To get the data in excel which contains 0's at start.
1st download the data in Notepad with "Tab delimited" format.
Then Open excel ....select open ...select ur file path of text file....
Select radio button "Delimited". clk Next.
Select chkbox according to the separator present in text file to separate 2 colums.
Clk Next.
Then select the entire data and select Chkbox "Text".
By this way u can get data as it is in excel.
regards,
ajit.