On Thu, 14 Apr 2005 13:26:15 -0700, James Wilkerson <James
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.

I cannot reproduce your results by following your directions.

When you say "entered 5420.06727" did you type that into the cell exactly, or
did you enter it some other way.

Do you see the same 5420.06726999999 when you do Print Preview?

What is the cell format?

What version of Excel and OS are you using?

What regional settings?


--ron