January 23, 2012
How to ignore more than 2 decimal places in excel
Problem: When formated cell with 2 decimal points is copy/pasted to another cell, it copies more than 2 decimal places as well
User doesn't want to see and calculate all decimal places, to copy only 2 decimal places.
Tools - Options - calculation
Precision as displayed
(warning message that calculation won't be precise on that particular document appears.
This should be repeated on every documents that user wants without all decimal places)
Precision as displayed options works only on current document.