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

I have one excel sheet. In that one cell value $1,544.13 when i click that cell it is showing 1544.12857142857 in formula bar.

I tried to set as General, but it does not show all the digits. It displays something like 1544.128571.

If I set the custom format to 0.00, I get 1544.13, but the formula shows 1544.12857142857.

Find the Excel sheet - Amount column has digits problem

How can I change the number format to show all decimal digits?

share|improve this question

migrated from Mar 11 '13 at 19:15

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

Format it as number with 11 digits:

enter image description here

Alternatively, you can also provide a custom format, such as #,##0.00000000000

share|improve this answer

You must log in to answer this question.