| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert number to word
i used the vb code
for 120 it shows the one hundred and twenty dollars and zero cents i dont want like this . in india dollars is not used . we used rupees and paise insted of cents. is ther any vb code so i can convert the dollarsinto ruppes and cents into paise 2nd question is that . 120 can be one hundred twenty only. i dont want rupees,paise or dollars and cents. i want only to convert one hundred twenty only. pls help me thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert number to word
Go and download the (free) ASAP utilities.
One of the macros (pop-out "numbers") will provide text (words) for any number - and you can choose whether or not to use dollars/rupees/or even cats & dogs!!! HTH -- mac "hitesh" wrote: i used the vb code for 120 it shows the one hundred and twenty dollars and zero cents i dont want like this . in india dollars is not used . we used rupees and paise insted of cents. is ther any vb code so i can convert the dollarsinto ruppes and cents into paise 2nd question is that . 120 can be one hundred twenty only. i dont want rupees,paise or dollars and cents. i want only to convert one hundred twenty only. pls help me thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert displayed number to absolute value | Excel Discussion (Misc queries) | |||
| Number in cell convert in word | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Linear Mode
