J
Jim
I want to convert formula result values to fixed text.
Any clues?
Any clues?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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
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)
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?
insert a define name name: info
ref to: =EVALUATE(sheet1!A1)
in sheet!a1 your formulas
in B1 type : =info
ivano