Instead of putting =Now() into the cell, put this formula in the cell
instead...

=DAY(NOW())&MID("thstndrdth",MIN(9,2*RIGHT(DAY(NOW ()))*(MOD
(NOW()-11,100)2)+1),2)&TEXT(NOW()," mmmm")&", "&YEAR(NOW())

--
Rick (MVP - Excel)


"enrico via OfficeKB.com" <u41845@uwe wrote in message
news:964b0a7d8dc2a@uwe...
what if your cell is updated, like the date would be today(=now( ))? i
believe the formulas are only good on which you will give the data

--
Message posted via http://www.officekb.com