xiaohu2007-10-20 11:39:22
偶要把数字自动转成文字,比如 1260,变成One Thoudsand Two Hundred sixty,
查了相关资料,有这个功能,可就是用不起来。用过的看能否帮一哈。


T(value) Converts a number to a blank text string. Value is the value to be converted. Also, a reference can be used as a parameter. If the referenced cell includes a number or a formula containing a numerical result, the result will be an empty string.

TEXT(number, format) Converts a number into text according to a given format. Number is the numerical value to be converted. Format is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format.


多谢了
yahoobb2007-10-20 14:20:53
google "excel convert number to english"
xiaohu2007-10-20 15:08:46
谢谢了。到底是人脑厉害,我还以为一个function 就行了呢