For example I have the number 5 in a cell and need to change it to the word five.
H Hoff Mar 23, 2006 #1 For example I have the number 5 in a cell and need to change it to the word five.
T Trevor Shuttleworth Mar 23, 2006 #2 Answer courtesy of xlDynamic.com which points to some Microsoft knowledge base entries. http://www.xldynamic.com/source/xld.xlFAQ0004.html XL2000: How to Convert a Numeric Value into English Words http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360 XL: How to Convert a Numeric Value into English Words http://support.microsoft.com/default.aspx?scid=KB;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 http://xcell05.free.fr/ Regards Trevor
Answer courtesy of xlDynamic.com which points to some Microsoft knowledge base entries. http://www.xldynamic.com/source/xld.xlFAQ0004.html XL2000: How to Convert a Numeric Value into English Words http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360 XL: How to Convert a Numeric Value into English Words http://support.microsoft.com/default.aspx?scid=KB;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 http://xcell05.free.fr/ Regards Trevor
G Gary''s Student Mar 23, 2006 #3 See: XL: How to Convert a Numeric Value into English Words http://support.microsoft.com/default.aspx?scid=KB;EN-US;q140704&;
See: XL: How to Convert a Numeric Value into English Words http://support.microsoft.com/default.aspx?scid=KB;EN-US;q140704&;