請教excel高手

偶要把數字自動轉成文字，比如 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.


多謝了

所有跟帖： 

• google "excel convert number to english" -yahoobb- ♀ (0 bytes) () 10/20/2007 postreply 06:20:53

• 謝謝了。到底是人腦厲害，我還以為一個function 就行了呢 -xiaohu- ♂ (10 bytes) () 10/20/2007 postreply 07:08:46