Microsoft Excel takes 8085002100000259 as 8085002100000250

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 ?

Excel works with 15 digits. If you pre-format column A as TEXT and then paste the account number in (Paste/Paste special/Text) in your it apears correctly as ....259. If you then enter =A1 in (say in F1) it appears correctly as ...259. The left justification in column F reassures you that it is STILL text.

Next time you make a mistake like that, can I send you MY bank account details??

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

For the record, cross posted on at least 3 other forums

Yes, I know - waiting for the OP to provide links.