how to stop changing 15 or 16 digit of number to 0

N

Nitish Sharma

while typing 16 digit bank account number in excel sheet it 15 and 16 digit
of the same authomatically changed to 0. Please tell me how to stop the same.
 
G

Gary''s Student

Either preceed the value with a single quote when typing or format the cell
to Text before typing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
16 digit number entry changes last digit to 0 1
Custom Format on 16 Digit Number 5
How can the font and size of (all) citation numbers be altered? 1
Why does Excel replace any digits beyond 15 with zeros? 2
How to restrict zeros in a number from 16th digit onwards 5
Number of significant digits allowed in a cell is 15. 2
Truncating Number Series 3

Top