@lm12abh wrote:
Thanks for this. The value is numerical from the source data and is either 13 or 16 digits. The issue occurs when I export the data to excel, the last 2 digits get replaced with trailing 0's. I need to keep all the information in excel and thus need to convert this to a string but I am having trouble doing this. Example:
Number Desired string obtained string
1234567891234567 1234567891234567 1234567891234500
How do I get my desired string.
You might show exactly how your are getting the values into Excel.
Also check your Excel cell properties to see if display has been set to round or truncate values. Excel is known to set properties that you didn't expect.
... View more