Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting date - caps (Office XP)

    Hi gang,
    I want to format my date with the first letter of the month capitalize.
    My Windows and Excel are in French and usually the month does not take a capital on the first letter unless it's a title.
    I want to format my date to show January 2009. I
    I personalized my format but can't seem to make the "J" in caps.
    Any ideas how I could do this?
    Tks
    Johanne Champagne
    Montreal (Quebec) CANADA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: Formatting date - caps (Office XP)

    I don't think you can do this with the French names of the months such as janvier etc.
    But you can specify that Excel should use English names even on a French system:
    - Select the cells you want to format.
    - Select Format | Cells...
    - Activate the Number tab (#1 in the screenshot)
    - Select Date in the list of categories (#2 in the screenshot)
    - Select English (UK) or English (United States) from the Locale dropdown (#3 in the screenshot).
    - Select a date format.
    - If you want to customize it, select Custom in the list of categories AFTER selecting a format that resembles the one you want.
    Attached Images Attached Images
    • File Type: gif x.gif (10.3 KB, 0 views)

Posting Permissions

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