- 1). Enter the header "Partial Cents" in row 1, column A.
- 2). Enter the header "Whole Cents" in row 1, column B.
- 3). Enter some sample data in column A:
row 2: 0.04300
row 3: 0.04800
row 4: 0.02500
row 5: 0.03400
row 6: 0.00200 - 4). Enter this formula in row 2, column B:
=ROUND(B2;2). - 5). Copy the formula from row 2 and paste it into row 3 through row 6, column B. Copy data by simultaneously selecting "Cntrl" and "C" on the keyboard. Paste data by simultaneously selecting "Cntrl" and "V."
SHARE