How To Translate Number into Text

[FAUZAN]

How to Translate : $ 4.567.123 become "Four Million Five Hundreds sixty Seven Thousands One Hundred Twenty three Dollar" using formula (Sorry, if i write it in wrong way). can it be translate to my language (Indonesia)?

 

[VoG]

Using VBA code, not a formula http://support.microsoft.com/kb/213360/en-us

 

[FAUZAN]

Can it convert a numeric value into Indonesian words

 

[VoG]

Can it convert a numeric value into Indonesian words

In principle - yes. You would need to replace the English words for Thousand and so on with the equivalent in Indonesian.

 

[FAUZAN]

Thank You Very much.