For example I have the number 5 in a cell and need to change it to the word
five.
Answer courtesy of xlDynamic.com which points to some Microsoft knowledge
base entries.
www.xldynamic.com/source/xld.xlFAQ0004.html
XL2000: How to Convert a Numeric Value into English Words
support.microsoft.com/default...;EN-US;Q213360
XL: How to Convert a Numeric Value into English Words
support.microsoft.com/default...;EN-US;Q140704
If you want a complete solution, then Laurent Longre has an addin that
provides language support and much more. You can get it
xcell05.free.fr/Regards
Trevorquot;Hoffquot; gt; wrote in message
...
gt; For example I have the number 5 in a cell and need to change it to the
gt; word
gt; five.
See:
XL: How to Convert a Numeric Value into English Words
support.microsoft.com/default...N-US;q140704amp;;--
Gary's Studentquot;Hoffquot; wrote:
gt; For example I have the number 5 in a cell and need to change it to the word
gt; five.
- Oct 22 Sun 2006 20:09
How do I convert a number in Excel to text?
close
全站熱搜
留言列表
發表留言