converting numeric date into aphabets

D

doom4

is this possible or any forumal, that can convert date into alphabets.

like if i have in a1 is 30.06.2006 or 30/06/2006, so in b1 i can get
thirty mayor(or sixth), two sound six.

cant found any where, any reference.

help.

thanx..
 
R

Roger Govier

Hi

You could create 2 named ranges using Insert>Name>Define>
One would be called Days and would look like
1 One
2 Two
3 Three
..
31 Thirty One

The other would be Years
2005 Two thousand and five
2006 Two thousand and six
etc.

Then your formula would be
=VLOOKUP(DAY(A1),Days,2,0)&" "&TEXT(MONTH(A1),"mmmm")&"
"VLOOKUP(YEAR(A1),Years,2,0)

-.-
Regards

Roger Govier
 
Top