S sandy Jul 28, 2008 #1 example if i have amount 1075/- how i can convert this amount in "one thousand seventy five only"
M macropod Jul 28, 2008 #2 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'
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'