Kindly Share the sheet On Sep 28, 1:09 pm, Anil Bhange <anil.bha...@tatacommunications.com> wrote: > Hi Experts, > > I wanted your help in below points, > > 1. In excel my companies Bank account number is more than 20 digit > > 2. And there are approx. 100 bank account numbers > > 3. When I copy those numbers from one excel to another digits after 15 > alphabet convert to "0" > > 4. What I understood is after 15 digit excel doesn't recognize the numbers > and convert it to "0" > > I tried using Value formula & Text formula but still it doesn't work because > at the time of copy paste it again converting to number format. > And if I do F2 and enter it shows "0" after 15 digit. > > Anil Bhange > > Assistant Manager > Financial Reporting & Compliance, > > TATA Communications Ltd. > VSB, Fort, Mumbai - 400 001, > India > > ' Desk : + 91 22 6659 2320 > | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 > > anil.bha...@tatacommunications.com<mailto:anil.bha...@tatacommunications.com>
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
