Results 1 to 11 of 11

Date format problem

Threaded View

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    Serbia
    MS-Off Ver
    Excel 2010
    Posts
    85

    Date format problem

    Hi,

    all my date entries:
    31.12.2012.
    31 12 2012
    31.12.2012
    31/12/2012
    31-12-2012

    can not be converted to dates. I am using "dd.mm.yyyy." as date format and never had any problems with it until I've tried to use that values in calculations (simple if...this date>that date).
    I've realized that calculations are only possible with mm.dd.yyyy.format.

    My question is, how can I continue to use dd.mm.yyyy. when entering dates in cells and in the same time retain their functionality?
    Last edited by Jovica; 09-01-2012 at 10:59 AM.

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