Formulas
 

I would like to know how to do a formula to convert a number in text.
Example: - 1.000 in A Thousand

What do you mean, you would like 1.000 to be converted to 1,000? Just
multiply by 1000... =A1*1000

If not clarify your question a bit more
--
Regards,
Dave


"Jota R" wrote:

I would like to know how to do a formula to convert a number in text.
Example: - 1.000 in A Thousand

Hi Jola,
Seems a bit ambiguous, but See links in
Numbers to words (as in check protection wording) )
http://www.mvps.org/dmcritchie/excel...numberstowords
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Jota R" <Jota wrote...
I would like to know how to do a formula to convert a number in text.
Example: - 1.000 in A Thousand