converting cell formulaes to code

H

Hein

Is there anyway that I can convert formulaes that is currently in cells to
code?

Thanks
 
S

Sheeloo

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...
 
S

Satyendra_Haldaur

If you want to see the formula instead of value in a cell u can use ctrl+ ` .
( ` is just above on tab)
 
S

Stefi

You can also toggle displaying formulae or results via
Tools>Options>Display>Formulae checkbox

Regards,
Stefi

„Hein†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I extract the decimal places from a number in excel? 3
Add - Trim(Clean()) 3
Protect workbook and hide formulaes 2
save workbook, erase data but keep formula 4
Excel Formulaes 4
Concatenate 1
Using Degrees in trigonometric functions 1
pROTECTING CELLS 1

Top