T
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.
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.