| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SpellNumber Function
http://support.microsoft.com/?kbid=213360 This is the basic spellnumb er macro form microsoft it spells number in english so i want ot convert it to convert numbers to arabic the main problems a in arabic we say like one thousand as one word and two thousand as one word too so i need to make a function that will cal l from 1000 to 9000 and same for hundred we say one hundred as one word and two hundred as one w ord so i need another function for hundred the other problem is that we write numbers from right to left like : 78 we spell it like eighty seven so i need to make the 78.76 spelled like eighty seven and sixty seven cents also we say eighty and seven and sixty and seven cents so i need and after each one so could any one help me in that i would be greatful Thanks KK -- capisco ------------------------------------------------------------------------ capisco's Profile: http://www.excelforum.com/member.php...o&userid=19569 View this thread: http://www.excelforum.com/showthread...hreadid=543629 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SpellNumber Function
KK<
Can you give some number examples and how you want to see the result? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "capisco" wrote in message ... http://support.microsoft.com/?kbid=213360 This is the basic spellnumb er macro form microsoft it spells number in english so i want ot convert it to convert numbers to arabic the main problems a in arabic we say like one thousand as one word and two thousand as one word too so i need to make a function that will cal l from 1000 to 9000 and same for hundred we say one hundred as one word and two hundred as one w ord so i need another function for hundred the other problem is that we write numbers from right to left like : 78 we spell it like eighty seven so i need to make the 78.76 spelled like eighty seven and sixty seven cents also we say eighty and seven and sixty and seven cents so i need and after each one so could any one help me in that i would be greatful Thanks KK -- capisco ------------------------------------------------------------------------ capisco's Profile: http://www.excelforum.com/member.php...o&userid=19569 View this thread: http://www.excelforum.com/showthread...hreadid=543629 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SpellNumber Function
Bob Phillips Wrote: KK< Can you give some number examples and how you want to see the result? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "capisco" wrote in message ... http://support.microsoft.com/?kbid=213360 This is the basic spellnumb er macro form microsoft it spells number in english so i want ot convert it to convert numbers to arabic the main problems a in arabic we say like one thousand as one word and two thousand as one word too so i need to make a function that will cal l from 1000 to 9000 and same for hundred we say one hundred as one word and two hundred as one w ord so i need another function for hundred the other problem is that we write numbers from right to left like : 78 we spell it like eighty seven so i need to make the 78.76 spelled like eighty seven and sixty seven cents also we say eighty and seven and sixty and seven cents so i need and after each one so could any one help me in that i would be greatful Thanks KK -- capisco ------------------------------------------------------------------------ capisco's Profile: http://www.excelforum.com/member.php...o&userid=19569 View this thread: http://www.excelforum.com/showthread...hreadid=543629 78 we spell it like eighty seven so i need to make the 78.76 eighty seven pounds and sixty seven piasters -- capisco ------------------------------------------------------------------------ capisco's Profile: http://www.excelforum.com/member.php...o&userid=19569 View this thread: http://www.excelforum.com/showthread...hreadid=543629 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SpellNumber Function
Showing some numbers and then using a different set of words for them
(78.76 - eighty seven pounds and sixty seven piasters?) doesn't really help me, and I don't understand when you say one hundred is one word? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "capisco" wrote in message ... Bob Phillips Wrote: KK< Can you give some number examples and how you want to see the result? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "capisco" wrote in message ... http://support.microsoft.com/?kbid=213360 This is the basic spellnumb er macro form microsoft it spells number in english so i want ot convert it to convert numbers to arabic the main problems a in arabic we say like one thousand as one word and two thousand as one word too so i need to make a function that will cal l from 1000 to 9000 and same for hundred we say one hundred as one word and two hundred as one w ord so i need another function for hundred the other problem is that we write numbers from right to left like : 78 we spell it like eighty seven so i need to make the 78.76 spelled like eighty seven and sixty seven cents also we say eighty and seven and sixty and seven cents so i need and after each one so could any one help me in that i would be greatful Thanks KK -- capisco ------------------------------------------------------------------------ capisco's Profile: http://www.excelforum.com/member.php...o&userid=19569 View this thread: http://www.excelforum.com/showthread...hreadid=543629 78 we spell it like eighty seven so i need to make the 78.76 eighty seven pounds and sixty seven piasters -- capisco ------------------------------------------------------------------------ capisco's Profile: http://www.excelforum.com/member.php...o&userid=19569 View this thread: http://www.excelforum.com/showthread...hreadid=543629 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is spellnumber function no more available in MS office 2007? | Excel Discussion (Misc queries) | |||
| SpellNumber function for Percentages? | Excel Discussion (Misc queries) | |||
| spellnumber function | Excel Worksheet Functions | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| PLEASE HELP with the SPELLNUMBER function | Excel Worksheet Functions | |||
Hybrid Mode
