If the number is XXXXX A2, use this formula to round to the nearest whole number
and make sure the cell that has the formula is formatted to Number with 2 decimal places
Hope this helps
Can I do more than one cell at a time? Can I round a whole column?
Yes, if the first value is in cell A2 and the last cell is in A100, place the formula that I gave you in B2, then use Fill Down or just drag it down through to cell B100
If you can't find Fill Down just copy cell B2 and paste it into B2:B100
select B2:B100 and press the CTRL + D keys
Thank you for remembering to rate my answer "Excellent" or "Good" if I was able to answer your question