Hey Anil,
Microsoft Excel stores numbers with up to 15 digits of precision. If a
number contains more than 15 significant digits, Microsoft Excel converts
the extra digits to zeros (0).
You have 2 options:-
You already know one of them
Put an apostrophe (') in front of the number.
That's OK for occasional use.
The other is to set the number format for the range of cells to Text
<format><cells><number tab>
Category: Text......Click [OK]
Now whatever you type in the cells will be interpreted as text, including
numbers and formulas.
On Wed, Sep 28, 2011 at 1:39 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****
>
> ** **
>
> ** **
>
> --
>
> ----------------------------------------------------------------------------------
> 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
>
--
.........................
--
----------------------------------------------------------------------------------
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
