+ Reply to Thread
Results 1 to 3 of 3

Dates Getting Messy

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    Brazil
    MS-Off Ver
    Excel 2016
    Posts
    46

    Dates Getting Messy

    Hello everyone!
    I'm trying to copy the cells from a sheet and transfer only the values to other sheet.
    I did it via code and it worked fine, except for the dates. In the new sheet the months and days are swapped.
    The original date is composed via the concatenate function, since it gets inputs (day, month and year) from the user in different cells. It's in the format D/M/YYYY (examples: 4/2/2014, 10/12/2013). I believe the excel interprets it as Text, even if I formated the cells to Date.
    I think it may have something to do with the default format in different countries. Here in Brazil we use DD/MM/YYYY, but my Excel is in english and in US the format is MM/DD/YYYY, am I right? Does this makes sense?
    Any ideas?
    Thanks a lot!

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Dates Getting Messy

    Which is your code?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-30-2014
    Location
    Brazil
    MS-Off Ver
    Excel 2016
    Posts
    46

    Re: Dates Getting Messy

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Messy Users
    By Dkso in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2006, 01:10 PM
  2. Messy tab characters
    By Gargoyl in forum Excel General
    Replies: 2
    Last Post: 04-19-2006, 06:15 PM
  3. [SOLVED] messy data
    By Adam in forum Excel General
    Replies: 4
    Last Post: 01-24-2006, 11:55 AM
  4. Eliminating all the messy workings
    By ray? in forum Excel General
    Replies: 5
    Last Post: 08-25-2005, 12:05 PM

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