Automate Form Filling with Excel

I am trying to fill out a form online using activity For Each Row. Everything works fine, but on my excel worksheet, one of the items is for account number, which is “001, 002, 003, 004” etc. It shows up on excel with the leading zeros as I have customized the format, but when it is entered on the online form, they automation only enters “1, 2, 3, 4”.

How do I get it to recognize the leading zeros?

Hi @Jenny_Ye welcome to forum

Check the preserve format option in read range and try it whether u are getting number along with leading zeros

Hope it helps :blush:

Regards

Nived N :robot:

Happy Automation :slight_smile::slight_smile::slight_smile::slight_smile::slight_smile:

2 Likes

Thanks! This worked!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.