| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
| spell number | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
