change automatically from 051010 yymmdd to 10/10/05 mm/dd/yy

[Guest]

EXCEL SPREADSHEET/NEED TO CHANGE A COLUMN OF DATE
HEADER ON SPREADSHEET YY/MM/DD 051010 NEED TO CHANGE
AUTOMATICALLY/TRYING NOT TO CHANE MANUALLY TO 10/10/05
MM/DD/YY

 

[Douglas J. Steele]

I'd suggest asking this in a newsgroup related to Excel. This one's for
questions about Access, the database product that's part of Office
Professional.

I'd also suggest turning off your Cap Locks key: typing in all upper case is
the visual equivalent of shouting, and is considered to be rude.

 

[fredg]

I'd suggest asking this in a newsgroup related to Excel. This one's for
questions about Access, the database product that's part of Office
Professional.

I'd also suggest turning off your Cap Locks key: typing in all upper case is
the visual equivalent of shouting, and is considered to be rude.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

EXCEL SPREADSHEET/NEED TO CHANGE A COLUMN OF DATE
HEADER ON SPREADSHEET YY/MM/DD 051010 NEED TO CHANGE
AUTOMATICALLY/TRYING NOT TO CHANE MANUALLY TO 10/10/05
MM/DD/YY

In addition to Doug's suggestion of your posting this to an Excel
newsgroup, I'd like to point out that your example of 10/10/05 is
ambiguous. Is it a month/day/year or day/month/year format? I'd
suggest you clarify that when you re-post.