| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Transform a Cell from Formula to Number
Is there a way to turn a cell from a formula to the number the formula outputs?
|
|
#2
|
|||
|
|||
|
Copy it to the clipboard, then do EditPasteSpceial, click Values
-- HTH Bob Phillips "Sloth" wrote in message ... Is there a way to turn a cell from a formula to the number the formula outputs? |
|
#3
|
|||
|
|||
|
Copy the cell. Edit/Paste Special/Values.
In article , "Sloth" wrote: Is there a way to turn a cell from a formula to the number the formula outputs? |
|
#4
|
|||
|
|||
|
Copy/Paste Special--Values
"Sloth" schreef in bericht ... Is there a way to turn a cell from a formula to the number the formula outputs? |
|
#5
|
|||
|
|||
|
Thanks guys. I love this forum.
"Sloth" wrote: Is there a way to turn a cell from a formula to the number the formula outputs? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| multiply by actual number in cell | Excel Worksheet Functions | |||
Linear Mode
