I cannot enter a number containing more than 15 digits in Excel

S

Sourav

I cannot enter a number containing more than 15 digits in Excel. Specialy
whwn the no is like 1668001700025402. after entry it displays like
1668001700025400 (even after changing the cell format into Number)
Pls give me response.
 
M

Ms-Exl-Learner

Select the range and do Right Click and select Format
Cells>>Number>>Category>>Text and give ok. Now enter the numbers in the
formatted cells.

Otherwise before entering the value in a cell type ' and enter your numbers.

But both the options will treat the number values as text.

Remember to Click Yes, if this post helps!
 

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

Showing 18 digits or more in a cell 1
Why does Excel replace any digits beyond 15 with zeros? 2
how to write 1234567890123456789 into a cell with number format 3
Excel is rounding off more than 16 digits ? 5
after 15 digits in excel sheet i am getting zeroes 1
How add a digit to front of number in each cell in excexl column 1
How do I prevent the cell from changing the number I enter? 2
Excel 2007 automatically corrupts my data!! 1

Top