Removing Decimals From The Formula Bar

[milwphil]

Good afternoon!

I have a spreadsheet in which a validation macro removes and rounds data that contains decimals within the cells;however, I noticed when I converted the spreadsheet to XML the decimals were still being captured and not rounded.

When I went back into the spreadsheet, the cell was rounded (no demimals-as intended), but in the formula bar the data maintained the decimal.

I tried formatting the cells without decimals, but it's not caught if the user cuts and pastes data.

How can I remove the decimals from the data in the formula bar?

Any suggestions?

Thanks,
Phil

 

[milwphil]

For once I answered my own question (Office 2010):
Office button > Excel Options > Advanced > When Calculating this workbook > Set precision as displayed.

 

[Datsmart]

Already answered...