I reproduced this (by directly entering 5420.06727 into a cell and
checking the value in the formula bar) in both Excel XP and Excel 2000).

This is probably another instance of the issue underlying

http://support.microsoft.com/default...;en-us;Q161234

Excel (and almost all other computer programs) stores numbers in binary,
not decimal

http://support.microsoft.com/default...b;en-us;Q78113
http://www.cpearson.com/excel/rounding.htm

The binary representation for 5420.06727 is <5420.06727 but
5420.067269999995, so it should be possible to display it as 5420.06727.

Based on previous discussions in the newsgroups, I believe this to be a
display issue, not a numeric issue. If so, then arithmetic will not be
impacted by this annoying issue. For instance if you enter 5420.06727
in A1 and 5420.06726999999 in A2, then =(A1-A2) will not be zero.

Jerry

James Wilkerson wrote:

I entered 5420.06727. When I print out the formulas the number is
5420.06726999999. I have tried basic formatting techniques, but it doesn't
fix it. My co-workers have had this issue with different numbers as well. How
do I fix this? I need the formula sheet to display the same thing as the data
sheet.