| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number to word | Excel Worksheet Functions | |||
| convert number to word | Excel Discussion (Misc queries) | |||
| HOW CAN I CONVERT NUMBER TO WORD | Excel Discussion (Misc queries) | |||
| convert number to word | Excel Discussion (Misc queries) | |||
| how to convert number in word in a xls | Excel Worksheet Functions | |||
Linear Mode
