Credit Card Numbers

We have a process that creates virtual credit cards through a providers website.

We scrape the CC numbers write them to a datatable, write the datatable to an Excel document then PW protect it and return the email.

The CC numbers recently have been becoming Scientific numbers in the Excel document. Short of adding the ’ to the begining of the string is there any other way of making them be written as text format

Hi @rmorgan

While writing you can use Text() in excel

=Text("12",00)

image

cheers

1 Like

hI @rmorgan

You can use format cell activity

Regards
Sudharsan

Hello @rmorgan

I hope you can use Format Cells activity to meet this requirement.

https://docs.uipath.com/activities/docs/format-range-x

Thanks

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