Number and Rounding format

[Guest]

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!

 

[Guest]

Select Tools->Options->Calculation and select the box next to "Precision as
Displayed"

Be carefull using this though you will permanently lose any precision, and
it effects all cells in the file. I usually use it once and then turn it off
because it effects functions results sometimes in unexpected ways.

 

[Ron Rosenfeld]

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!

First backup your data so as to save the original values (if you might need
access to them in the future).

Then select Tools/Options/Calculations
Under Workbook Options SELECT: Precision as Displayed


--ron