Leading zeros

Discuss RoboTask here

Leading zeros

Postby b_f_mcd@yahoo.com » Fri Mar 15, 2019 5:54 pm

I am reading social security numbers from an excel file and they are formatted as "000-00-0000" Robotask drops the leading zero on the number. I have searched everywhere i the forums and cannot figure out how to fix this.
b_f_mcd@yahoo.com
 
Posts: 1
Joined: Fri Mar 15, 2019 5:49 pm

Re: Leading zeros

Postby Oleg » Sat Mar 16, 2019 4:00 pm

Look at this parameter (see screenshot)
Image

If you use default parameter (General format (auto)) then EXCEL set this value as a number and suppresses lead zeros
Use "Set values as text" value. In this case EXCEL set value as-it-is and set the cell format to text
Oleg Yershov
Oleg
Site Admin
 
Posts: 2406
Joined: Thu Jan 01, 1970 1:00 am


Return to General Discussion

Who is online

Users browsing this forum: Google [Bot] and 10 guests

cron