Copy whole number value ONLY

[Thea]

How can I copy the whole number value into another cell.
For example cell A1 already has 9,991.55 but I need to
copy into cell B1 9,992. I have tried reformatting the
cell after pasting but it still retains the original
number from cell A1 thus making autosum a nightmare when I
try to foot my column of numbers.

The Goal: There would be no decimal places in the new cell
when you click on the cell (i.e B1) AND it would be
rounded up to the nearest whole number).

Please help. Thank you.

 

[Molly]

Instead of copying cell A1, use a formula as follows in
cell B1:

=ROUNDUP(A1,0)