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:
verey verey usefull to me
thanks alot
Post a Comment