Date as Words

R

Rick@T

I have to print out certificates with the date printed as
words i.e. the twenty-second day of February two thousand
and four.

Is there anyway to get the software to print dates in this
fashion?
 
F

Frank Kabel

Hi
there're some macros/procedures to convert numbers to text. e.g.
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods


If you use for example Morefunc.dll (the function NBTEXT) and your cell
A1 stores a date value try
=NBTEXT(DAY(A1)) & " of " & TEXT(A1,"MMMM") & " " & NBTEXT(YEAR(A1))
 
Top