how to get serial number in word? like 1=one, 2=two
 

Respected sir,

i wanna know, how to get serial numbers in word insteasd of numericals

example

when i put value in A1 automaticaly i get the answer in shape of serial
number in word in B1 column

A1 B1
===========
01 ONE
02 TWO

quick response will be highly appreciated.

Malik Nadeem
cell # 00923002556512

how to get serial number in word? like 1=one, 2=two
 

If you just need the numbers one to nine, try this:
=CHOOSE(A1,"One","Two","Three","Four","Five","Six" ,"Seven","Eight","Nine")

If you need to write 421 as four hundred and twenty-one, then you need a
macro. There are multiple examples around, try a search with "macro", "excel",
"spell" and "Number".

Stephane Quenson.


Malik Nadeem wrote:
Respected sir,

i wanna know, how to get serial numbers in word insteasd of numericals

example

when i put value in A1 automaticaly i get the answer in shape of serial
number in word in B1 column

A1 B1
===========
01 ONE
02 TWO

quick response will be highly appreciated.

Malik Nadeem
cell # 00923002556512

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1

how to get serial number in word? like 1=one, 2=two
 

This macros as good as any
http://www.ozgrid.com/VBA/ValueToWords.htm
Mike

"Malik Nadeem" wrote:

Respected sir,

i wanna know, how to get serial numbers in word insteasd of numericals

example

when i put value in A1 automaticaly i get the answer in shape of serial
number in word in B1 column

A1 B1
===========
01 ONE
02 TWO

quick response will be highly appreciated.

Malik Nadeem
cell # 00923002556512

how to get serial number in word? like 1=one, 2=two
 

Download the NumsToWords VBA function file from this website:
http://www.contextures.com/excelfilesRon.html

With a click of a button the file will put the VBA code into the workbook
you select.
(The file has instructions)

Then.....

With
A1: (a number or numeric text, like: 1 or 01)

Enter this formula in
B1: =NumsToWords(A1,"","","",TRUE)

If A1 = 05, B1 returns: Five
If A1 = 12, B1 returns: Twelve

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"Malik Nadeem" wrote:

Respected sir,

i wanna know, how to get serial numbers in word insteasd of numericals

example

when i put value in A1 automaticaly i get the answer in shape of serial
number in word in B1 column

A1 B1
===========
01 ONE
02 TWO

quick response will be highly appreciated.

Malik Nadeem
cell # 00923002556512

how to get serial number in word? like 1=one, 2=two
 

thank you very much for your prompt response Stephane i realy appreciate you.
could you please guide me how can i find salution of this 421 number to word
as you wrote in your following msg there are multiple example in search with
"macro", "excel", "spell" and "Number".

thanks in advance for your great support and help..

Regares
Malik Nadeem



"squenson via OfficeKB.com" wrote:

If you just need the numbers one to nine, try this:
=CHOOSE(A1,"One","Two","Three","Four","Five","Six" ,"Seven","Eight","Nine")

If you need to write 421 as four hundred and twenty-one, then you need a
macro. There are multiple examples around, try a search with "macro", "excel",
"spell" and "Number".

Stephane Quenson.


Malik Nadeem wrote:
Respected sir,

i wanna know, how to get serial numbers in word insteasd of numericals

example

when i put value in A1 automaticaly i get the answer in shape of serial
number in word in B1 column

A1 B1
===========
01 ONE
02 TWO

quick response will be highly appreciated.

Malik Nadeem
cell # 00923002556512

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1

how to get serial number in word? like 1=one, 2=two
 

Have a look here at Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Sun, 19 Aug 2007 22:46:00 -0700, Malik Nadeem
wrote:

thank you very much for your prompt response Stephane i realy appreciate you.
could you please guide me how can i find salution of this 421 number to word
as you wrote in your following msg there are multiple example in search with
"macro", "excel", "spell" and "Number".

thanks in advance for your great support and help..

Regares
Malik Nadeem



"squenson via OfficeKB.com" wrote:

If you just need the numbers one to nine, try this:
=CHOOSE(A1,"One","Two","Three","Four","Five","Six" ,"Seven","Eight","Nine")

If you need to write 421 as four hundred and twenty-one, then you need a
macro. There are multiple examples around, try a search with "macro", "excel",
"spell" and "Number".

Stephane Quenson.


Malik Nadeem wrote:
Respected sir,

i wanna know, how to get serial numbers in word insteasd of numericals

example

when i put value in A1 automaticaly i get the answer in shape of serial
number in word in B1 column

A1 B1
===========
01 ONE
02 TWO

quick response will be highly appreciated.

Malik Nadeem
cell # 00923002556512

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1