Two final thoughts on this:

If 5420.06727 is a constant entered in a cell, you could use the
following VBA function to verify that the value is stored correctly (VBA
does not share Excel's problem with correctly displaying certain
floating point numbers)

Function whatVal(x As Double) As String
whatVal = CStr(x)
End Function

Whether 5420.06727 is a constant or part of a formula, you could
sidestep the issue by using the equivalent formula of 542006727/100000
which will display correctly.

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.