Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to put 19 digit or more digit number in a excel cell.

I want to save 19 digit number in cell of column .How I will format that cell.Can anybody give me some idea in this regard?

share|improve this question

migrated from Feb 4 '10 at 18:28

This question came from our site for professional and enthusiast programmers.

Huh? Is it not letting you? – ceejayoz Feb 4 '10 at 18:10
Can you describe the problem you're trying to solve? What application requires a 19 digit number? – deed02392 Feb 20 '13 at 15:15

You can always store the number in the cell as a string. Put an apostrophe in front of the number.

share|improve this answer

If you change the format of the cell to 'Text', you don't need to prepend an apostrophe; you just put in the number. It will still even be usable as a number by functions that refer to the cell.

share|improve this answer

When you don't need to calculate with these numbers, you can treat them as text, see the other answers. When you need to calculate with them, then it becomes difficult because Excel has only 15 siginificant digits. The possibilities I know are:

  1. Split the number in 2 (or more) cells. Put a part of the number in one cell and the remainder in another cell. The consequence is that you need to develop your own formules for calculations.
  2. Another solution is using add-in's. For a free one study the articles mentioned in
share|improve this answer

Excel seems to allow only 15 digits. What on Earth are you doing that really requires 19 digits of precision? I suspect you're either not stating your problem well or you're worry about unnecessary details.

share|improve this answer

It is simple to copy / type in excel with more than 15 numbers. Pls follow the steps given below:

  1. If you want to type a number which is more than 15 digits, simply select that particular column, go to format cells, and select "text". After that, whatever numbers you type it will give you in text format.

  2. If you want to copy a number which has more than 15 digits, simply, first copy and paste that particular number/rows/columns into notepad, again copy the content from notepad, go to excel select full sheet and right click to select format type as "text", and now past the copied content in the excel. It automatically shows you all the digits without any rounded off.

share|improve this answer

Formatting as text does not work for me. However, when I added the single quotation mark Excel (finally) treated the digits as a text string and did not change the final digit.

share|improve this answer
same answer already exists Maurits Rijk i am voting up to balance as i do not see anything wrong with your answer even thought duplicate. not sure why many of the other answers have 2 votes up when they are equally useless and single liners – SeanClt Mar 31 at 19:05

You must log in to answer this question.