Hi.
I am looking to paste 5 digit number from collection to excel csv file.
Unfortunately preceding 0 is not copied and number would become 4 digit. Ex: 08976 would become 8976 after excel writes the collection into CSV file.
Can somebody please help me how to keep the number format Text for a particular cell here. I tried using "@" in MS Excel format Cell Action, but not helpful. If i use apostrophe Ex: "'@", number would be 5 digit but apostrophe gets appeared ('08976)in the cell value which gives me error while backfilling values in my DB as apostrophe is considered as string.
In short, i want to write the 5 digit value which may have preceding 0. From collection to Excel CSV file.
Thanks in advance.
Sandeep
I am looking to paste 5 digit number from collection to excel csv file.
Unfortunately preceding 0 is not copied and number would become 4 digit. Ex: 08976 would become 8976 after excel writes the collection into CSV file.
Can somebody please help me how to keep the number format Text for a particular cell here. I tried using "@" in MS Excel format Cell Action, but not helpful. If i use apostrophe Ex: "'@", number would be 5 digit but apostrophe gets appeared ('08976)in the cell value which gives me error while backfilling values in my DB as apostrophe is considered as string.
In short, i want to write the 5 digit value which may have preceding 0. From collection to Excel CSV file.
Thanks in advance.
Sandeep