Excel date 20100915 without formatting

Microsoft Office excel 2007 home & stude...
February 2, 2011 at 04:30:29
Specs: Windows XP
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!

See More: Excel date 20100915 without formatting

Report •

February 2, 2011 at 04:43:25
Drag this formula down alongside your dates:


Next, do a Copy...PasteSpecial...Values to eliminate the formula.

Then format the cells as General

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 2, 2011 at 04:55:38
DerbyDad03, that worked perfectly!! Thank you so much!!

Report •

Related Solutions

Ask Question