Format column to Numer PESEL in Excel

[Richarlei_Reis]

I need help to format column B and C to (Special>>Polonês>>Numer PESEL) in Excel

before

after

[singh_sumit (Sumit Singh Tariyal)]

Hey @Richarlei_Reis
use excel application scope activity to get the file which you used for the process
then write the vb script in notepad

Sub FormatPESEL()
Columns(“B:C”).NumberFormat = “00000000000”
End Sub
and save this script as .vbs extension then use the invoke vba activity select the vba file and write the entry method FormatPESEL

cheers

[ashokkarale]

@Richarlei_Reis,

Use Format Cells activity for this. It’s an excel activity. It will give you all the options to choose from.