Microsoft Excel takes 8085002100000259 as 8085002100000250 which caused fund transfer to wrong Bank Account

[ashakantasharma]

Hi All Community Members,

I would like to share a strange problem with Microsoft Excel. We tried to initiate some Bill Payments to our Suppliers for which an Excel Sheet needs to be filed with Supplier bank details like Account Number, IFSC Code, Amounts etc which gets uploaded at Bank Site to be approved by Authorized Management Peoples.

I have noted that even one of the Bank Account we copied which was 8085002100000259 got pasted as 8085002100000250 in the Excel Sheet which caused the funds to be transferred to wrong Bank Account. However it does not happen when we paste the data with an " ' " but when we double click on the cell and past the same it gets pasted as 8085002100000250 instead of 8085002100000259

Using Windows 10
Using Microsoft Office 2019

This is a VERY DANGEROUS Situation for us. Why this is happening and how to fix the same immediate basis ?

 

[Fluff13]

Cross posted on multiple sites.
I suggest you read the rules https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

 

[ashakantasharma]

Cross posted on multiple sites.
I suggest you read the rules https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

Thanks Fluff...It is fix now..

 

[vletm]

ashakantasharma
The cross-posting ...
Did You read those Forum Rulse? ... seems You skipped those,
because there are clear procedure - what to do, if use cross-posting.

Read this about last digits are changed to zeros when you type long numbers in cells of excel

Last digits are changed to zeros when you type long numbers in cells of Excel - Microsoft 365 Apps

Describes that Excel can store only 15 significant digits in a number. If the number that you type contains more than 15 digits, any digits past the fifteenth digit are changed to zero. Format the number as text to work around this problem.

docs.microsoft.com

Copy & paste works well ... if can use it well.

 

[ashakantasharma]

ashakantasharma
The cross-posting ...
Did You read those Forum Rulse? ... seems You skipped those,
because there are clear procedure - what to do, if use cross-posting.

Read this about last digits are changed to zeros when you type long numbers in cells of excel

Last digits are changed to zeros when you type long numbers in cells of Excel - Microsoft 365 Apps

Describes that Excel can store only 15 significant digits in a number. If the number that you type contains more than 15 digits, any digits past the fifteenth digit are changed to zero. Format the number as text to work around this problem.

docs.microsoft.com

Copy & paste works well ... if can use it well.

Thanks a lot

 

[pecoflyer]

You had received the solution on another forum on Dec 20th...If you had read the rules you would already have communicated that...