• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

ashakantasharma

ashakantasharma

New Member
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 ?
 
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
docs.microsoft.com

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.
 
vletm said:
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
docs.microsoft.com

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.
Click to expand...
Thanks a lot
 
You had received the solution on another forum on Dec 20th...If you had read the rules you would already have communicated that...
 
You must log in or register to reply here.
Back
Top