How to Change Excel Scientific format to String

Some Excel Data Formats are like that “8.32489E+23” . How to read and change into String when I want to get full text?
Regards,
Soe Min Latt.

Hey @Soe_Min_Latt,

When you will read the data from excel you will automatically get the full text.You do not need to do anything specific for that.

Use Excel Application Scope and Read Range Activity to achieve this.Read Range activity will return datatable as output argument which will have the data format as string by default.

1 Like

Hello @amarasto , Thanks for your answers.
But I don’t get fullText.

Data in Excel like that “8.32489E+23”
I want to data like that “832488970307990975269250”

Regards,
Soe Min Latt

Hey @Soe_Min_Latt,

Ideally when you read the excel using excel application scope and read range activity it always gives you the complete data.However you will always see the scientific value in the excel cell because that is the excel formatting.

If Still you are not getting the expected value then i would suggest you to format the excel column as text in that case excel can not take decision on its own and will leave the data as is.

1 Like