If you want a formula for use in a different column, use this...

=TEXT(A1,"ddmmyyyy")

If you want to simply change the appearance of your date in the same cell,
use Format/Cell and this Custom format... ddmmyyyy

--
Rick (MVP - Excel)


"bill2" wrote in message
...
Hi,
How do I write formula for a 8 digit date without / so that it appears as
a
8 digit number: ie, 2/12/99 as 02121999?
Thanks!