I cannot write numeric 17 digit in Excel

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by jonkool
Best Answer
Best Answer
Answered By 0 points N/A #115271

I cannot write numeric 17 digit in Excel

qa-featured

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.

Answered By 0 points N/A #115272

I cannot write numeric 17 digit in Excel

qa-featured
  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

Related Questions