TDM Excel plugin truncating number data with 000

[jsmalley]

I have a strange one. I have created a TDM file with several groups and channels. One of my channels has the name IMEI_MEID and the data shows 270113178003159793.  When this channel imports to excel the number is changed to 27011317800315000.  I'm not sure why this is happening. I saved the data in the TDM file as a DDC_String so it should be ok.

My plugin version is 2.1.0.4.

[jsmalley]

Forgot to mention that when I view this in DIAdem there is no issue with the data. It's just truncated in Excel which I assume was due to the plugin. 

[Walter_Rick]

Hi jsmalley,

It seems to be a problem with Excel in general. If you edit in Excel a number with more than 15 significant digits this phenomenon occurs. Example:

123456789012345111 is shown in Excel as 123456789012345000

It is not a problem of the Excel Add-In.

Greetings
Walter

[jsmalley]

Thanks. I had never run into that before. It's true that if I type in 18x 1's   the last 3 are converted to 0's.