Prev: having two separate column width controls on same worksheet
Next: Excel pausing
From: MICHALK on 27 Jan 2010 16:42
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.
From: Fred Smith on 27 Jan 2010 17:28
Use the text function, as in:
=text(a1,"mmddyy")

Regards,
Fred

"MICHALK" <MICHALK(a)discussions.microsoft.com> wrote in message
news:D02A0056-6B71-411C-BDAD-8094312A47DC(a)microsoft.com...
> 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.

From: Dave Peterson on 27 Jan 2010 17:35
=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
From: Gord Dibben on 27 Jan 2010 17:39
=TEXT(cellref,"mmddyy")


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 13:42:01 -0800, MICHALK
<MICHALK(a)discussions.microsoft.com> 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.

From: MICHALK on 28 Jan 2010 12:12


"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!!

 |  Next  |  Last
Pages: 1 2
Prev: having two separate column width controls on same worksheet
Next: Excel pausing