Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i want to convert the Currency appering in Number to Characters
like i have 2568.38
in another cell i need Two thousand five hundred Sixty Eight Dollars and Cents Thirty Eight, in fact i had this functioin in my excell before but not after i update i can't find it. i got the program some where from Microsoft website, can any one help me please |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
i want to convert the Currency appering in Number to Characters
Saif,
Here's the code http://support.microsoft.com/kb/213360 Mike "Saif" wrote: like i have 2568.38 in another cell i need Two thousand five hundred Sixty Eight Dollars and Cents Thirty Eight, in fact i had this functioin in my excell before but not after i update i can't find it. i got the program some where from Microsoft website, can any one help me please |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
i want to convert the Currency appering in Number to Character
Thanks mike, Tested Ok, this was exactly what i need
Thanks, "Mike H" wrote: Saif, Here's the code http://support.microsoft.com/kb/213360 Mike "Saif" wrote: like i have 2568.38 in another cell i need Two thousand five hundred Sixty Eight Dollars and Cents Thirty Eight, in fact i had this functioin in my excell before but not after i update i can't find it. i got the program some where from Microsoft website, can any one help me please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert number to Million Currency format | Excel Worksheet Functions | |||
Convert number to word in indian currency | Excel Worksheet Functions | |||
I type in a number in a cell but it wont convert to currency help | Excel Worksheet Functions | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
Formatting Currency Without Any Special Characters | Excel Discussion (Misc queries) |