information
spchoube wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
Eg. : 150500
One Lac Fifty Thousand Five Hundred
like this
please forward me this question answer, i waiting four reply on my email account
My e mail Account : spchoube@rediffmail.com
thanking you,
shreenivas prabhakarrao choube
|
how to convert number into text
ali wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
Eg. : 150500
One Lac Fifty Thousand Five Hundred
|
how to convert number into text
bhupesh wrote on February 08, 2006 23:55 EST |
[QUOTE=ali]how to convert number into text (acutal formating)
Eg. : 150500
One Lac Fifty Thousand Five Hundred[/QUOTE]
:)
Coverting number into text
Ex: 150
One hundred fifty |
how to convert numric into words
ravikanth wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
Eg. : 150500
One Lac Fifty Thousand Five Hundred
like this
please forward me this question answer,
My e mail Account : rzkancherla@kanbay.com
Ravikanth
|
how to convert numric into words
alexander wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
Eg. : 150500
One Lac Fifty Thousand Five Hundred
like this
please forward me this question answer,
My e mail Account : alex_22@rediffmail.com
S.Alexander
|
how to convert numeric into words
O´Neill wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
Eg. : 150500
One Hundred and Fifty Thousand Five Hundred
like this
please forward me the answer to this question,
My e mail Account : poneill@adinet.com.uy
Thks |
wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
Eg. : 150500
One Lac Fifty Thousand Five Hundred
Coverting number into text
Ex: 150
One hundred fifty
please forward me the answer to this question,
My e mail Account : fmhjcd@yahoo.com
Thks |
Vaibhav wrote on December 31, 1969 18:00 EST |
To convert number into text (acutal formating)
Eg. : 150500
One Lac Fifty Thousand Five Hundred you will need a add in which converts number to texts which generally doesnt comes with MS excel. Go to ant search engine you will get it. |
convert numeric to word english
JC Barman wrote on December 31, 1969 18:00 EST |
say 150500 convert to One Lac Fifty Thousand Five Hundred
|
how to convert number into text (acutal formating)
HARI wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
E.G 1750.50
ONE THOUSAND FIVE HUNDRED & FIFTY
MY EMAIL ID IS belltextiles@batsons.co.in
|
Convert Number into Text
Jagdish Joshi wrote on December 31, 1969 18:00 EST |
how to convert number into text
Eg. : 150500
One Lac Fifty Thousand Five Hundred
like this
please forward me this question answer,
My e mail Account : jagdishjoshi01@indiatimes.com
Jagdish Joshi |
convert numeric value to text
pcperv wrote on January 16, 2007 00:25 EST |
I have the same question as the rest. I would like to know the solution to the problem.
numerical value:
1,754.25
convert to:
One Thousand Seven Hundred Fifty-four and 25/100
Please reply at my e-mail: [email]pcperv.pico@gmail.com[/email]
Thanks. |
oldchippy wrote on January 17, 2007 09:59 EST |
[QUOTE=pcperv]I have the same question as the rest. I would like to know the solution to the problem.
numerical value:
1,754.25
convert to:
One Thousand Seven Hundred Fifty-four and 25/100
Please reply at my e-mail: [email]pcperv.pico@gmail.com[/email]
Thanks.[/QUOTE]
Here are a number of links for the code to convert numbers to text
[url]http://www.ozgrid.com/VBA/ValueToWords.htm[/url]
[url]http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360[/url]
[url]http://xcell05.free.fr/english/morefunc/nbtext.htm[/url]
In your particular case you need to separate the whole number from the decimal by firstly using
=ROUNDDOWN(A1,0) in cell B1 and
=RIGHT(A1,2)&"/100" in cell C1, if you use the first link for your code then you could CONCATENATE this onto
=SpellNumber(B1)&" and "&C1 |
how to convert number into text
edwin wrote on December 31, 1969 18:00 EST |
how to convert number into text
Eg. : 150500
One Lac Fifty Thousand Five Hundred
like this
please forward me this question answer,
My e mail Account : edwin_joseph23@rediffmail.com
edwin joseph |
convert number into text
P K BASU wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
Eg. : 150500
One Lac Fifty Thousand Five Hundred
like this
please forward me this question answer, i waiting four reply on my email account
My e mail Account : pkbasu@slofindia.com
|
convert number into text
Sachin wrote on December 31, 1969 18:00 EST |
how to convert number into text (acutal formating)
Eg. : 150
One Hundred Fifty Only
like this
please forward me this question answer, i waiting four reply on my email account
My e mail Account : sbwani74@yahoo.co.in
|
The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
