Pasting values to Excel removes leading zeroes
Hi.
My automation involves copying a value that contains leading zeroes and then pasting it to Excel. The automation copies "0077788", but when it's pasted, Excel somehow deletes the leading zeroes. Manually, I can use the "Format Cells" option in Excel and click Text, but how do I do that in the automation?
***Updated by moderator: Lochan to add Categories***
Posted: 2 years ago
The default data format for Excel sheets eats leading zeros like that. There's no way to modify formatting with the connector; you'll have to pre-set the format for the cells.