Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Mar 11 '13 at 19:15

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.