The issue I am having is that when I export a 16 digit number in to Excel, Excel is displaying the number as 8.92752E+14. Now I understand why this is happening however I do not know how to correct it.
I have tried prefixing a "'" to the number so that the digits will be recognised as text but this displays as '12324567895698568 where I need 12324567895698568.
does anyone have any suggests?
/Nice
I have tried prefixing a "'" to the number so that the digits will be recognised as text but this displays as '12324567895698568 where I need 12324567895698568.
does anyone have any suggests?
/Nice