Changing dates

[MICHALK]

How do you change a date to text and return a string such as mmddyy to
replace 01/01/10? In other words remove the slashes but keep the same
numbers.

 

[Fred Smith]

Use the text function, as in:
=text(a1,"mmddyy")

Regards,
Fred

 

[Dave Peterson]

=text(a1,"mmddyy")
if A1 contained the date

Or just format the cell using a custom format:
mmddyy

 

[Gord Dibben]

=TEXT(cellref,"mmddyy")


Gord Dibben MS Excel MVP

 

[MICHALK]

=text(a1,"mmddyy")
if A1 contained the date

Or just format the cell using a custom format:
mmddyy

THANKS SO MUCH!!

 

[MICHALK]

Use the text function, as in:
=text(a1,"mmddyy")

Regards,
Fred



.
Thanks so much!!

 

[MICHALK]

=TEXT(cellref,"mmddyy")


Gord Dibben MS Excel MVP



.
THANKS SO MUCH!!