This is my first attempt to gain assistance from this group - in the past I have been happy to lurk (the connotations this engenders beggars belief) simply because I don't have the time available when at work. Even so, I have discovered some amazing solutions/hints from the digest version. Anyhow, now it's time to dive in the deep end (so to speak). I have assumed responsibility for the management and update of a large amount of data in MS Excel (V97-SR2)(approx 12,000 lines & growing all the time) which utilises a pivot table to summarise the data and provide totals. The problem I have found is that, whilst the data is formatted to 2 decimal places, some of the pivot table totals can be generated to 10+ decimals. Some of the totals fields are copied/paste special/values into another worksheet so that the data can be manipulated and input through another process to update further records. I have discovered that the decimalisation problems in the pivot table totals have caused errors in the input of the data at the next stage. I have attempted to re-format the total field in the pivot table without success - there must be a way around this annoying problem. Any assistance would be greatly appreciated. As a footnote - I am from the "land down-under" and it is now 05:00 pm on Friday afternoon. We also have a public holiday on Monday so I will not be able to respond to any e-mails until Tuesday morning. Kind Regards Ian Warton Project Controls Group Tenix Defence Ltd (03) 9244-4982 E-mail - ian.warton@xxxxxxxxx -- Binary/unsupported file stripped by Ecartis -- -- Type: application/ms-tnef -- File: winmail.dat ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************