| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting cell formulaes to code
Is there anyway that I can convert formulaes that is currently in cells to
code? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting cell formulaes to code
What do you mean by code?
If you want to convert them to values then Copy and then Edit|Paste Special|Values If you want to convert them into the formula, simply replace = with '=. You can do that by Find/Replace option... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Hein" wrote: Is there anyway that I can convert formulaes that is currently in cells to code? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting cell formulaes to code
If you want to see the formula instead of value in a cell u can use ctrl+ ` .
( ` is just above on tab) "Hein" wrote: Is there anyway that I can convert formulaes that is currently in cells to code? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting cell formulaes to code
You can also toggle displaying formulae or results via
ToolsOptionsDisplayFormulae checkbox Regards, Stefi €˛Hein€¯ ezt Ć*rta: Is there anyway that I can convert formulaes that is currently in cells to code? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULAES | Excel Worksheet Functions | |||
| Converting EasyLanguage code to Excel | Excel Discussion (Misc queries) | |||
| Files and formulaes | Excel Worksheet Functions | |||
| Help with Macros or formulaes | Excel Discussion (Misc queries) | |||
| UDF problem in converting data into code 128 B | Excel Worksheet Functions | |||
Hybrid Mode
