Results to text

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
Copy it (them) and with out selecting a copy-to do a Select Edit
Paste-Special Values, Ok
 
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)
 
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
 
You must log in or register to reply here.

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

Text to values 4
Offset a formula result 1
Match function: error due to format? 4
Find a phrase in a string and convert it to a number 5
VLOOKUP source values are a formula result. Getting #N/A 7
Function/Formula for Text Conversion 3
count - but exclude counting cells with a formula 4
SUMIFS using a text range 2

Back
Top