Prev: links
Next: How can I copy big ranges of cells without drag or copy/paste?
From: Excellency on 22 Mar 2010 16:56
Hi

I have a cell for example that displays 03/07 as a text field for month and
year. I want it converted to date field to display as = mar-07 or march 2007.
when I use format or text function it converts to 03/07/2010. I dont want to
have the current year display instead it should display 2007.
From: Fred Smith on 22 Mar 2010 17:28
Use:
=date(right(a1,2),left(a1,2),1)
and format as: mmm-yy or mmmm yyyy

Regards,
Fred

"Excellency" <Excellency(a)discussions.microsoft.com> wrote in message
news:C6CA08AE-6CB4-440C-AE9D-96EE6CB08747(a)microsoft.com...
> Hi
>
> I have a cell for example that displays 03/07 as a text field for month
> and
> year. I want it converted to date field to display as = mar-07 or march
> 2007.
> when I use format or text function it converts to 03/07/2010. I dont want
> to
> have the current year display instead it should display 2007.

 | 
Pages: 1
Prev: links
Next: How can I copy big ranges of cells without drag or copy/paste?