I have a column which displays "122". But when you look at the actual cell
contents in the formula field, it displays as "121.5". The column is
formatted as a "Number" column with 0 decimal places. I am importing this
column into a 3rd party application, and it is importing as "121.5". And I
need it to import as the displayed rounded amount of "122".

Is there any way that I can easily adjust this within the Excel spreadsheet
or am I going to have to invoke the "ROUND" formula function in each of the
almost 20,000 cells to accomplish this???

I appreciate any feedback.

Thanks!