ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How we convert number in to word (https://www.excelbanter.com/excel-worksheet-functions/196518-how-we-convert-number-word.html)

Sandy

How we convert number in to word
 
example if i have amount 1075/-
how i can convert this amount in "one thousand seventy five only"

macropod[_2_]

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"



All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com