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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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
 
Back
Top