数以Excel程序字(句) [英] Number to word (sentence) in Excel program

问题描述

我想知道如何更改数目成字符串(如，1"给出一个"，22给出22" .....在Excel ???

解决方案

尝试
http://www.yogeshguptaonline.com/2009/07/excel-functions-转换号码-into.html [ ^ ]
http://support.microsoft.com/kb/213360 [ ^ ]
http://www.ozgrid.com/VBA/CurrencyToWords.htm [ ^ ]

尝试
如何图转换为词 [ ^ ]

和一个可能的，但真的快速和肮脏的解决方案，如果您有只小可能的选择量，是在工作表上创建一个映射表，如:
<预郎=文本">列A列B -------- -------- 1一 2两 ... 22二十二个
然后使用 VLOOKUP [ ^ ]来获取文本.

I want to know how I change number into string (ex, "1" gives "one" ,22 gives "twenty two".....in Excel???

解决方案

Try
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html[^]
http://support.microsoft.com/kb/213360[^]
http://www.ozgrid.com/VBA/CurrencyToWords.htm[^]

Try
How to convert Figures to Words[^]

And one possible, but really quick and dirty solution, if you have just small amount of possible choices, is to create a mapping table on a worksheet, like:

Column A   Column B
--------   --------
1          One
2          Two
...
22         Twenty two

And then use VLOOKUP[^] to fetch the text.

这篇关于数以Excel程序字(句)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！