How we convert number in to word

[sandy]

example if i have amount 1075/-
how i can convert this amount in "one thousand seventy five only"

 

[macropod]

Hi Sandy,

See: http://support.microsoft.com/kb/q95640/

you can use the function there in an Excel cell via:
=ConvertCurrencyToEnglish(A1)
where the value to be converted is in A1. If '5' is in A1, the function will return 'Five Dollars And No Cents'