ExcelBanter - How can I convert the result of a formula to a whole number?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I convert the result of a formula to a whole number? (https://www.excelbanter.com/excel-discussion-misc-queries/85789-how-can-i-convert-result-formula-whole-number.html)

crystal

How can I convert the result of a formula to a whole number?

I have a row of numbers which are the result of a formula in each cell. I
now want to copy those results and use in another spread sheet. How can I
convert the numbers to whole numbers that are not dependent on the formula?

Trevor Shuttleworth

How can I convert the result of a formula to a whole number?

copy | paste special | values

Regards

Trevor

"crystal" wrote in message
...
I have a row of numbers which are the result of a formula in each cell. I
now want to copy those results and use in another spread sheet. How can I
convert the numbers to whole numbers that are not dependent on the
formula?

All times are GMT +1. The time now is 11:40 PM.