How to save Exponential number

[pra_kale]

Hi,

I am facing one problem while saving data where between numbers E appears. It automatically converts values in Exponential so while saving data it converts into 0.

Actual member number in front of 123567 is 00E24 and where as in front of 45678 value is 00E23.

In excel also value getting converted into exponential.

Can you pl help to resolve the issue.

Thanks in Advance.

sunny‌

marcus_sommer‌

[boorgura]

It appears that Excel is not even holding the value 00E24. The value itself is being saved as "0".

Is it an option to update the source? say - format of the cell as text?

[eduardo_dimperio]

Hi, try use Round(YourData)