Hi Anil
If you are not doing calculation with numbers then you can change the format
to text
check whether this helps
http://office.microsoft.com/en-us/excel-help/display-numbers-as-credit-card-numbers-HA010236840.aspx
HTH
Mahesh
On Wed, Sep 28, 2011 at 9:39 PM, XLS S wrote:
> Hey Anil,
>
>
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
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
