Formatting a Cell for a Specific Number

Posted on 2011-10-15
Last Modified: 2013-11-05
I need to have the cells to be formatted a specific way - they will be either 13- or 16-digits.  

Right now, it seems like the 13 digits are showing up OK, but the 16 digits are being reformatted - mainly the last number is being changed from what I enter to a "0".  For example, if I enter 4444444444444444, Excel changes it to 4444444444444440.  I have tried General and Special but they don't seem to work.  

What format can I use so that Excel will show the specific number?

I am using Excel 2010 Professional Plus.

Thank you!
Question by:coreybryant
    LVL 92

    Accepted Solution

    Excel has a maximum precision of 15 significant digits for numeric values.  That is why your 16th digit is becoming a zero.

    If you need to enter 16 digit numbers, change the number format to Text before you do your data entry.  Excel will then treat the values as text and not numbers.
    LVL 29

    Author Closing Comment

    Thanks - that was it.  Since I was copying / pasting the number from another cell, I was also copying that other cell's formatting.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now