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?