I would like to know how to do a formula to convert a number in text. Example: - 1.000 in A Thousand
J Jota R Oct 1, 2005 #1 I would like to know how to do a formula to convert a number in text. Example: - 1.000 in A Thousand
D David Billigmeier Oct 1, 2005 #2 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
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
D David McRitchie Oct 1, 2005 #3 Hi Jola, Seems a bit ambiguous, but See links in Numbers to words (as in check protection wording) ) http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords
Hi Jola, Seems a bit ambiguous, but See links in Numbers to words (as in check protection wording) ) http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords
