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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
Click to expand...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



BEV said:
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
Click to expand...

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.
 
Back
Top