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
Go To Solution
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.

About jonkool
Questions
0
Answers
3
Best Answers
2
  • Posted on -
  • Question Category:
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

About zicooo82
Questions
0
Answers
11
Best Answers
1
  • Posted on -
  • Question Category:

Full of Desktop with banner of "thayet myo hacking day"

Previous

Problem with my virus scanner, can someone help?

Next

Related Questions