View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hardeep_kanwar[_2_] Hardeep_kanwar[_2_] is offline
external usenet poster
 
Posts: 103
Default Unexpected Result

Hi! All Expert

Today i have generate some data from our software.

This data look like Below mentioned

5555555555100025
5555555555100033
And so on.

But when i copy this Data in excel it show as:

5555555555100020 and so on

It replace the last digit with 0

And in some data it replace the last digit with 00 like below example

55555555551000030


I have never Seen this type of Unexpected Result in Excel

Please help me on this issue

Hardeep kanwar