How to Convert Number Stored as Text in Excel?

[Sreekar_Mulinti]

[Jose_Cunha (José Cunha)]

Hello.

Try this.

Convert cell or range value from text to number [Excel][Vb]

Hi @prasath17 , I cant really use the Build Datatable or for loop , since it changes the data type or format of the data and lastly the data will be between thousands and lakhs (large data)

[ushu (Usha kiranmai)]

@Sreekar_Mulinti Try using Change Cell Format Activity

BalaReva

[muhammedyuzuak]

Hi @Sreekar_Mulinti,

Doesn’t it work for you if you read the text and convert it? If it doesn’t work, you can read all the excel and add the fields you want to a new dt with the adddatarow activity in the loop with the format you want.

Regards,
MY