Changing dates
 

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.

Changing dates
 

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

Regards,
Fred

"MICHALK" wrote in message
...
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.

Changing dates
 

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

Or just format the cell using a custom format:
mmddyy



MICHALK wrote:

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.

--

Dave Peterson

Changing dates
 

=TEXT(cellref,"mmddyy")


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 13:42:01 -0800, MICHALK
wrote:

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.

Changing dates
 

"Dave Peterson" wrote:

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

Or just format the cell using a custom format:
mmddyy



MICHALK wrote:

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.

--

Dave Peterson
.

THANKS SO MUCH!!

Changing dates
 

"Fred Smith" wrote:

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

Regards,
Fred

"MICHALK" wrote in message
...
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.

.
Thanks so much!!

Changing dates
 

"Gord Dibben" wrote:

=TEXT(cellref,"mmddyy")


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 13:42:01 -0800, MICHALK
wrote:

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.

.
THANKS SO MUCH!!