Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Art Gerald Ranque (agranque)
Sun Life Financial Inc

Sun Life Financial Inc
PH
agranque Member since 2017 9 posts
Sun Life Financial Inc
Posted: Jan 19, 2018
Last activity: Jan 22, 2018
Posted: 19 Jan 2018 3:33 EST
Last activity: 22 Jan 2018 20:58 EST
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***

To see attachments, please log in.
Robotic Process Automation

Posted: 6 years ago
Posted: 22 Jan 2018 20:58 EST
Andrew Grondin (grona) GCS Solutions Engineer I
Pegasystems Inc.
US

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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice