Thread: How we convert number in to word
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macropod[_2_] macropod[_2_] is offline
external usenet poster
  
Posts: 293
Default How we convert number in to word
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'

--
Cheers
macropod
[MVP - Microsoft Word]


"sandy" wrote in message ...
example if i have amount 1075/-
how i can convert this amount in "one thousand seventy five only"
Reply With QuoteReply With Quote