How do I copy and paste the rounded number, not the decimal pointed number? Example: I have an amount in cell A1 of 110.75 and I want to paste 111, or the rounded up equivalent. I want the cell to read 111, not just be formatted without the decimals, so that if it is parsed it will be parsed as 111.