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 ?

 

[Rick Rothstein]

Format the cell you want to put that number in as Text first and then enter the number into the cell afterwards (otherwise Excel tries to put it in as a calculatable number which is limited to 15 digits).

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: multiple sites
Please provide links to all sites where you have asked this question.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[ashakantasharma]

Format the cell you want to put that number in as Text first and then enter the number into the cell afterwards (otherwise Excel tries to put it in as a calculatable number which is limited to 15 digits).

Thanks for the response...Stay blessed and happy....

 

[Fluff]

@ashakantasharma
Please supply the links to the other sites where you have asked this question, as requested.

 

[ashakantasharma]

@ashakantasharma
Please supply the links to the other sites where you have asked this question, as requested.

Hi Fluff,

The below are the links as requested:
1. Microsoft Excel takes 8085002100000259 as 8085002100000250 which caused fund transfer to wrong Bank Account

2. Microsoft Excel takes 8085002100000259 as 8085002100000250

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

Thanks and have a great time ahead...

 

[Fluff]

Thanks you

 

[Rick Rothstein]

Hi Fluff,

The below are the links as requested:
1. Microsoft Excel takes 8085002100000259 as 8085002100000250 which caused fund transfer to wrong Bank Account

2. Microsoft Excel takes 8085002100000259 as 8085002100000250

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

Thanks and have a great time ahead...

If you haven't already done so, you should post the link to this thread at each of those forums and mention your question was answered so that volunteers there don't waste their time developing an answer to your question there.