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.

Excel:
Tools - Options - calculation
Workbook options

mark;
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.

1 comment:

samehamen said...

verey verey usefull to me
thanks alot