close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()