How to read correct format if cell includes "E" Value

Feedback Activities
, , ,
1

Hi All!

When I used read range for excel , column contains “E” value. For example number 1,

image
image244×558 66.5 KB

How to fix this issue i want to get number 2 value

3

Hi @Betul_Dundar

Can try This syntax

image
image953×237 11.4 KB

Cheers!

4

Hi @Betul_Dundar

Have you tried with Enable the Preserve format from the Read rnage activity?

image

Regards

5

Hi @Betul_Dundar ,

Are you using the Modern activities in Excel to read and write the data? I’ve tried repro’ing this and the data was copied correctly across even without changing the Read formatting on the Use Excel File.

Many thanks,
Raluca

6

Hi @Betul_Dundar , quick ping here to check if you are using the Modern activities when this is happening. Would you be able to share a sample workflow?

7

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