.. It worked fine in my tests.
And it worked fine for me over here, too <g

Big Rick:

With Bob's sub implemented properly,
Select and *pre-format* the designated input range: H1:H10
as Custom: dddd dd mmmm yyyy

Then test by inputting some dates within H1:H10
When you press ENTER to commit each input,
Bob's code will return exactly what you're after

(My guess is you either didn't pre-format H1:H10 beforehand, or you might
have tried out the inputs elsewhere .. in A1, A2?? [I dunno]. But don't ask
me why Bob prefers "H1:H10" instead of "A1:A10" as the assumed source input
range <g)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--