Numbers errors

Numbers errors

Post by Anil Bhang » Thu, 29 Sep 2011 17:09:57



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


 
 
 

Numbers errors

Post by hemal sha » Thu, 29 Sep 2011 21:03:54


Better to add single quote ( ' ) before bank account number .

and while you copy that number to another cell, it will remain same.

 
 
 

Numbers errors

Post by sagg » Thu, 29 Sep 2011 20:33:21


Kindly Share the sheet



> 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



 
 
 

Numbers errors

Post by XLS » Fri, 30 Sep 2011 01:09:09


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 <


> 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 doesnt recognize the
> numbers and convert it to 0****

> ** **

> I tried using Value formula & Text formula but still it doesnt 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 ****


> ** **

> ** **

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 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


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

--
.........................
 
 
 

Numbers errors

Post by Mahesh para » Fri, 30 Sep 2011 01:22:29


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-credi...

HTH
Mahesh


> 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 <

>> 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 doesnt recognize the
>> numbers and convert it to 0****

>> ** **

>> I tried using Value formula & Text formula but still it doesnt 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 ****


>> ** **

>> ** **

>> --

>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip

>> 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


>> <><><><><><><><><><><><><><><><><><><><><><>
>> 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

> 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


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

 
 
 

1. Format Number Error

I am having a problem with Excel 5.0.  I am running Windows95 with Excel 5.0
for windows 3.1.

When I format numbers in comma format (123,456,789.99) the commas come up as
boxes (like check boxes).  

I have the Excel viewer and the comma show up fine, but not in the program.

Any one have any suggestions?

They will will greatly appreciated.

Henry Lifton

2. Calendar in Frontpage?

3. RAR file numbering error?

4. HP All-In-One Printing Problem (single check)

5. Bad Article number errors

6. Windows Error

7. Bad Major Version Number Error?

8. Netscape/2 2.02 update... bulleted text glitch

9. numbering errors: generating a book file

10. "Number of shapes does not match number of table records" error box

11. Article Rejected : Server Error: 441, Error Number: 0x800CCCA9

12. Server Error:559, Error Number:0x800CCC61

13. ftp: SSL/TLS connect COMMAND error: error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number