• 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

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 ?
 

vletm

Excel Ninja
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
Copy & paste works well ... if can use it well.
 

ashakantasharma

New Member
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
Copy & paste works well ... if can use it well.
Thanks a lot
 

pecoflyer

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