Previous Topic Next Topic

Excel 2007 date 20100915 without formatting

Closed
heidist - Feb 2, 2011 at 06:43 AM
 Steveinuk - Feb 2, 2011 at 10:14 AM
Hello,

I have a column of dates (around 800 rows) with dates entered in as 2010/09/15 as date format. I need to convert these to GENERAL format and have them entered as 20100915.

Does anyone know how I can do this quickly and easily? I'm not familiar with VBA at ALL!! If you could walk me through it step by step I'd really appreciate it!!

Thank you all for your help!
Related:

1 response

Answer 1 / 1
Steveinuk
Feb 2, 2011 at 10:14 AM
=CONCATENATE(TEXT(YEAR(A1),0),TEXT(MONTH(A1),0),TEXT(DAY(A1),0))

or you could just change the format?
Custom format and put yyyymmdd in the type box.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses