Date Formatting

[catfish]

I need to change the date format for a column from 01/15/2006 to 01152006 .
Is this possible to do?
Thanks

 

[Mike H]

Try,

Custom format of

mmddyyyy

Mike

 

[Gord Dibben]

Custom format of mmddyyyyy

If you want it as text

=TEXT(cellref,"mmddyyyy") in a helper cell


Gord Dibben MS Excel MVP