You can prefix a single quote ('09) to the value before writing to excel. This will retain the 0. Please keep this in mind if you want to process the excel file further.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Force excel to recognize numbers as text when pasting from datatable | 4 | 7268 | March 4, 2021 | |
| How to achieve format with preceding 10 zeros to any digit in excel? | 21 | 3757 | August 2, 2021 | |
| Datatype column set to string but leading zeros removed | 2 | 1479 | March 4, 2021 | |
| Writing to Excel drops leading 0s | 12 | 4842 | May 19, 2021 | |
| Facing issue withe Excel format while Write text file data into Excel | 10 | 2532 | August 17, 2019 |