James Wilkerson

Posts: n/a

Precision displayed does not match precision in cell

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Look up data in colum a and find match in colum b	Chris(new user)	Excel Discussion (Misc queries)	1	March 22nd 05 01:41 PM
Look up data in colum a and find match in colum b	Chris(new user)	Excel Discussion (Misc queries)	1	March 19th 05 09:27 PM
Precision as displayed	Susan Lambert	Setting up and Configuration of Excel	1	December 17th 04 07:36 PM
Find a match that;s not exact	Phyllis	Excel Worksheet Functions	0	November 8th 04 08:12 PM
Vlookup, Index & Match	Phyllis	Excel Worksheet Functions	1	November 8th 04 06:11 PM

All times are GMT +1. The time now is 03:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us