8/1/2007 to 20070801

[QuietRiot]

I created a macro to do this but is there a way of converting a date to year month day without code?

8/1/2007 to 20070801

 

[ExcelChampion]

=YEAR(A1)&TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")

or just format...

yyyymmdd

 

[ADAMC]

Custom format of:

yyyyddmm ?

 

[dave3009]

Hi could you not use customer format yyyyddmm for that?

Problem would be is that it'd still be stored as a number

HTH


Dave

 

[barry houdini]

Try

=TEXT(A1,"yyyymmdd")

 

[jongooligan]

How about the other way round?

From 20070801 to 8/1/2007.

 

[barry houdini]

How about the other way round?

From 20070801 to 8/1/2007.

Assuming that's not a formatted date....

If you want to convert in the same cell you can use text to columns. At step 3 choose date format and YMD.

With a formula in another cell

=TEXT(A1,"0000-00-00")+0

format as date

 

[jongooligan]

Formula works a treat - Thanks.
Can see what +0 does but don't understand why.