Copy / paste

[Alexander]

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.

 

[Anne Troy]

I don't think it's possible to PASTE the rounded number. Where do you want to paste it? Into another cell/worksheet/workbook? Same cell?

 

[Alexander]

I want to paste it into another cell.

 

[Anne Troy]

Don't paste.

Just use =ROUND(A1,0)

Where A1 is the cell that currently contains 110.75

 

[Alexander]

Thanks! That works!