Very urgent: To get values displayed properly on the exported data

[faizumarali]

"Hi when i export data from an application to excel some numbers are not properly shown. For example ,if i export a value 720707886 from an application it looks like 7.207E+16 in excel. I heard that there is a formula to get the correct value.Could anybody please help me on this. Thank you."

 

[JimM]

Can you not just reformat the approriate column as a number ??

 

[faizumarali]

Hi jim,

I have tried all those possible stuffs like formate cell,numers and all. but no results. There is formula to reveal the exact value but unfortunately i don't know it.

 

[JimM]

Try

=VALUE(A1)

Assuming 7.207E+16 is in cell A1

 

[faizumarali]

Hi Jim,

it's working fine. Thanks a lot.