I am experiencing a bizarre phenomenon in Excel. I received a file from a
customer and there is an instance where, multiplying two cells together, the
answer is incorrect by about 0.02%. I am dealing with large numbers so I
cannot ignore this. I am not a beginner with Excel and have checked all
possibilities such as ensuring cell format is number and not text, etc. Its
almost like its rounding the values off in the background, but its not. Has
anyone got any ideas?