Odd date format

  • Thread starter Thread starter CindyH
  • Start date Start date
C

CindyH

In Column A I need to format a date, without dashes or slashes, in this way:
yymmdd

In Column B I need Excel to recognize it as a date, in that order and
convert it to a regular date such as:
mm/dd/yy

Is there any way of doing this? It's driving me crazy. Surely there has to
be a way.

TIA!

Cindy

Cindy
 
Hi Cindy,

Can be done, but a lot simpler is to do it the other way around:

Enter the date in Column A as mm/dd/yy
In column B: =A1, Format>Cells>Custom, in the Type box, enter yymmdd

If you really need it otherwise: post again!

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
column a - format, cells, number, custom and enter yymmdd
column b - format cells, date and select mm/dd/y
 
one way

relax :)

format the A column as text

enter your 6 digit number in A1

in B1 enter =(MID(A1,3,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,2))

copy down

Regards
Bill K
 
Back
Top