Question

1
Replies
116
Views
agranque Member since 2017 7 posts
Sun Life Financial Inc
Posted: 2 years ago
Last activity: 2 years 7 months ago
Closed

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***

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn