Formatting a Cell for a Specific Number

Posted on 2011-10-15
Medium Priority
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 93

Accepted Solution

Patrick Matthews earned 2000 total points
ID: 36974092
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

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

807 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