Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by BEV, Nov 19, 2005.

  1. BEV

    BEV
    Expand Collapse
    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
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    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
    http://I.Am/DougSteele
    (no e-mails, please!)



    "BEV" <BEV@discussions.microsoft.com> wrote in message
    news:195943D0-8C3D-4FD0-9912-1F2C0A2CA7FC@microsoft.com...
    > 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
     
  4. fredg

    fredg
    Expand Collapse
    Guest

    On Fri, 18 Nov 2005 11:29:04 -0500, Douglas J. Steele wrote:

    > 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
    http://I.Am/DougSteele
    (no e-mails, please!)



    "BEV" <BEV@discussions.microsoft.com> wrote in message
    news:195943D0-8C3D-4FD0-9912-1F2C0A2CA7FC@microsoft.com...
    > 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.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page