Excel Date Format Help

December 6, 2010 at 11:37:58
Specs: Windows XP
I am working with thousands of lines of data and the date format is currently mm/dd/yyyy. I need the date to be formated as yyyymm.

Is there a way to do this without typing them out again? Thank you.


See More: Excel Date Format Help

Report •


#1
December 6, 2010 at 12:05:45
What you want is Custom Formatting

On 2007

Home tab,
Format,
Format Cells,
Custom

then enter your format: yyyymm

In 2003 it's

Format,
Cells,
Custom

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question