Spell out date
hi
oops. reread your post. how about a custom format???
dd"th day of "mmmm", "yyyy
regards
FSt1
"FSt1" wrote:
hi
not a formula but 3 formulas with concatinators.
date in b2?......
=DAY(B2)&"th Day of "&TEXT(B2,"mmmm")&", "&YEAR(B2)
regards
FSt1
"ProudFoot" wrote:
Is there a formula or VBA code to make "July 8, 2008" automatically say "8th
day of July, 2008"?
Any help is appreciated.
|