|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 31st, 2010, 02:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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. 
|
|
#2
May 31st, 2010, 02:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
|
#3
May 31st, 2010, 04:53 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
