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

ashakantasharma

Board Regular
Joined
May 28, 2020
Messages
86
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. Mobile
  3. Web
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 ?
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,860
Office Version
  1. 2010
Platform
  1. Windows
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).
 
Solution

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,470
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
May 28, 2020
Messages
86
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. Mobile
  3. Web
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,470
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

ashakantasharma

Board Regular
Joined
May 28, 2020
Messages
86
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. Mobile
  3. Web

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,470
Office Version
  1. 365
Platform
  1. Windows

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,860
Office Version
  1. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,444
Messages
5,624,811
Members
416,056
Latest member
VARSHA V VASWANI

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top