|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 09:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com