date formula

  • Thread starter Thread starter bill2
  • Start date Start date
B

bill2

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!
 
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
 
Back
Top