+ Reply to Thread
Results 1 to 2 of 2

Month day confusion

  1. #1
    VPH
    Guest

    Month day confusion

    When working with worksheets from other countries Excell will confuse month
    and days. How can I correct this - change what excell thinks is a month to a
    day - and vise versa.
    Thanks


  2. #2
    Niek Otten
    Guest

    Re: Month day confusion

    Excel does not confuse them. The dates are stored as numbers, and
    represented according to the formatting.
    This formatting may be "wrong" for you: Format>Cells>Date, pick a format you
    like.

    There are exceptions. If you import csv files for instance, or in certain
    cases if you fill your cells from VBA.

    For "normal" worksheet use, however, just reformatting should do.

    --
    Kind regards,

    Niek Otten

    "VPH" <VPH@discussions.microsoft.com> wrote in message
    news:8418361C-1D6F-4AF2-90E1-E2BEDC690CA1@microsoft.com...
    > When working with worksheets from other countries Excell will confuse
    > month
    > and days. How can I correct this - change what excell thinks is a month
    > to a
    > day - and vise versa.
    > Thanks
    >




+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1