Pivot table inaccuracies

dk · Feb 16th, 2002, 09:30 AM

Hello,

I've posted this to the Excel programming newsgroup but I'll put it here as well just to get a wider audience.

I have a pivot table with an Access database query as it's source. In the
pivot table some numbers are shown to 10 decimal places e.g.
35657.8299999998 but ONLY in the formula bar. In the table it is shown
correctly as 3567.83 exactly. The source records making up this total are
financial transactions (pounds and pence) and are therefore all at 2 decimal
places (I have checked that this is the case). Is this a known problem and
does anyone have a solution/workaround?

Excel 2000/Access 2000/Windows 2000 Pro

Cheers,
Dan.

dk · Feb 16th, 2002, 09:34 AM

Just noticed an error with that. In the table the amount shown is 35657.83, not 3567.83 as originally stated.

Regards,
D

dk · Feb 16th, 2002, 01:42 PM

Please ignore my posts - I'm being thick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 16th, 2002, 09:30 AM	#1
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hello, I've posted this to the Excel programming newsgroup but I'll put it here as well just to get a wider audience. I have a pivot table with an Access database query as it's source. In the pivot table some numbers are shown to 10 decimal places e.g. 35657.8299999998 but ONLY in the formula bar. In the table it is shown correctly as 3567.83 exactly. The source records making up this total are financial transactions (pounds and pence) and are therefore all at 2 decimal places (I have checked that this is the case). Is this a known problem and does anyone have a solution/workaround? Excel 2000/Access 2000/Windows 2000 Pro Cheers, Dan.

Feb 16th, 2002, 09:34 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Just noticed an error with that. In the table the amount shown is 35657.83, not 3567.83 as originally stated. Regards, D

Feb 16th, 2002, 01:42 PM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Please ignore my posts - I'm being thick