+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Date Separator in Excel

  1. 03-18-2009, 11:31 AM #1
    Northsea Medic
    Northsea Medic is offline
    Registered User
    Join Date
    03-18-2009
    Location
    Lowestoft
    MS-Off Ver
    Excel 2007
    Posts
    5

    Date Separator in Excel

    Hi, quick question for all those IT types out there... For years I have set my computer to accept a full stop (.) as a date separator rather than using a forward slash (/). We have just been given Vista at work and am now getting to grips with Office 2007. Can anyone tell me how to set my PC to accept the full stop as the separator? The context that this is in is only really for Excel e.g. to type in today’s date I used to enter 18.3.9 and it would auto correct it to 18.03.09.
    This was previously changed through the ‘Regional Settings’ option but the option is no longer there...

    Cheers

    NSM
    Last edited by Northsea Medic; 03-22-2009 at 11:47 AM.
    Reply With QuoteRegister To Reply
  2. 03-18-2009, 07:46 PM #2
    ianmaggy
    ianmaggy is offline
    Registered User
    Join Date
    03-17-2009
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Date Separator in Excel

    Those parameters can be changed in the control panel.

    Here are the steps

    Start
    Control Panel
    Regional and Language Options
    Under the format tab, Hit the customize this format... button
    Under the Date tab you can change the short date format. Your options are either a / or a - to be used as a separator
    Reply With QuoteRegister To Reply
  3. 03-22-2009, 11:45 AM #3
    Northsea Medic
    Northsea Medic is offline
    Registered User
    Join Date
    03-18-2009
    Location
    Lowestoft
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Date Separator in Excel - SOLVED

    Hi, I'm not sure what happened with previous posts but they never seemed to make it onto here.

    My question has now been solved....

    You get into the regional & language options
    Click customize this format
    Select the date tab
    The drop down list for short dates can then be edited to the format you require - in my case dd.MM.yy

    Cheers

    NSM
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1