Date Format Problem
 

I have a worksheet with a column formatted as 022008 which is suppose to mean
Feb 2008 or 02/2008. I can't seem to figure out how to change the cell format
to reflect this. I want it to display 02/2008.

Date Format Problem
 

In another cell enter:

=LEFT(A1,2) & "/" & RIGHT(A1,4)

or

=DATE(RIGHT(A1,4),LEFT(A1,2),1) and format as mm/yyyy
--
Gary''s Student - gsnu201003


"Alain" wrote:

I have a worksheet with a column formatted as 022008 which is suppose to mean
Feb 2008 or 02/2008. I can't seem to figure out how to change the cell format
to reflect this. I want it to display 02/2008.

Date Format Problem
 

That's OK if the 022008 is text, but if it is the number 22008 formatted as
000000, you'd need to change to

=LEFT(TEXT(A1,"000000"),2) & "/" & RIGHT(A1,4)
or
=DATE(RIGHT(A1,4),LEFT(TEXT(A1,"000000"),2),1)

You might instead try
=TEXT(A1,"00\/0000")
or (if your Windows Regional Options are appropriately set)
=--TEXT(A1,"00\/0000") formatted as mm/yyyy
--
David Biddulph


"Gary''s Student" wrote in message
...
In another cell enter:

=LEFT(A1,2) & "/" & RIGHT(A1,4)

or

=DATE(RIGHT(A1,4),LEFT(A1,2),1) and format as mm/yyyy
--
Gary''s Student - gsnu201003


"Alain" wrote:

I have a worksheet with a column formatted as 022008 which is suppose to
mean
Feb 2008 or 02/2008. I can't seem to figure out how to change the cell
format
to reflect this. I want it to display 02/2008.