Prev: having two separate column width controls on same worksheet
Next: Excel pausing
From: MICHALK on 28 Jan 2010 12:12


"Fred Smith" wrote:

> 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.
>
> .
> Thanks so much!!
From: MICHALK on 28 Jan 2010 12:13


"Gord Dibben" wrote:

> =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.
>
> .
> THANKS SO MUCH!!
First  |  Prev  | 
Pages: 1 2
Prev: having two separate column width controls on same worksheet
Next: Excel pausing