Results to text

P

Peo Sjoblom

What do you mean by fixed text? If you want to remove the dependency of a
formula, select it,
copy it and paste special as values in place.. If you need a number like 100
converted to "One Hundred"
you would need VBA. Laurent Longre has that included in one of his UDF
functions here

http://longre.free.fr/english/

the function is called NUMTEXT
 
J

JMay

Copy it (them) and with out selecting a copy-to do a Select Edit
Paste-Special Values, Ok
 
B

Bob Phillips

Jim,

Select the cells
Copy to the clipboard
Menu Edit>PasteSpecial, click the Values button, and OK

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I

ivano

Jim said:
I want to convert formula result values to fixed text.
Any clues?
Click to expand...

insert a define name name: info
ref to: =EVALUATE(sheet1!A1)
in sheet!a1 your formulas

in B1 type : =info

ivano
 

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

Wrapping and Anchors 0
Using formula to convert date result to text 3
Difficulty with compatibility mode and Track Changes 2
WordPad blocked content 2
Converting URLs in comments to Markdown-formatted links 2
Replace in a group or selection or collection of word files 1
Drop down list control value in vba 2
Creating multiple text fields 0

Top