I cannot write numeric 17 digit in Excel

Asked By johnnahin 0 points N/A Posted on - 08/15/2011

My PC’s operating system is Windows XP SP2. I am using Microsoft Excel 2007. I cannot write above 13 digit in here. If I write, it automatically is converted in different mode. Such as (1.0000 + 13).

I want to write 17 digit number in my Excel cell. Is it possible?

If possible how can I write it?

• Status: Open
• Question Views: 1966
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by jonkool

Go To Solution

Best Answer

Best Answer

Answered By jonkool 0 points N/A #115271

I cannot write numeric 17 digit in Excel

Hi Dear,

Follow the instructions to solve this problem.

1. Open Excel.
2. Then click “Home” from the menu bar.
3. Click on “Format”.
4. Click on “Format Cells’’ from the drop down menu.
5. Then click “number” Button.
6. Then select the “Text” from the drop down menu.
7. Click on “ok”.

Then it will be solved.

Thanks.

About jonkool

Questions
0

Answers
3

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/15/2011
• Question Category: MS Excel

Answered By zicooo82 0 points N/A #115272

I cannot write numeric 17 digit in Excel

1. Select the cells that you want to overload the size of the digits.
2. Right click and choose format cells.
3. From Number tab choose the category "Custom".
4. Under type there is a text box just write zeros as long as you want to maximize.

     – For example:

        00000000000000000

About zicooo82

Questions
0

Answers
11

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/17/2011
• Question Category: MS Excel