+ Reply to Thread
Results 1 to 2 of 2

Excel Dates copied from CSV file dont show as Dates

  1. #1
    Registered User
    Join Date
    04-02-2012
    Location
    Earth
    MS-Off Ver
    Excel 2013
    Posts
    33

    Excel Dates copied from CSV file dont show as Dates

    hi I have a CSV file with lots information in. I copy this information to an excel document to create tables etc.

    everything copies fine except the dates. the dates are formatted 2013-08-01 ie yyyy-mm-dd

    I have changes the column type at destination to match this format but unless I enter each cell it does not pick up the format.

    the code to copy data across is

    Please Login or Register  to view this content.
    what can I change to make this work as I want it to - thanks
    Last edited by vew32; 09-27-2013 at 04:25 AM.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Excel Dates copied from CSV file dont show as Dates

    You can include the following code in the next line of the code for pasting the data........

    Please Login or Register  to view this content.
    Moderator Note:

    Pls use code tags around your code next time as per forum rules.
    Last edited by Fotis1991; 09-27-2013 at 09:38 AM.

+ 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. Replies: 1
    Last Post: 06-18-2013, 06:32 PM
  2. Charting Dates I dont want
    By tactical in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-20-2011, 10:31 AM
  3. x-axis dates dont match up with the nodes on the line graph
    By changetires in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2006, 08:50 AM
  4. show nearst of two dates in new cell on excel
    By matt clarke in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-12-2006, 06:35 PM
  5. [SOLVED] Getting Excel on new computer to show dates like on old
    By MichaelC in forum Excel General
    Replies: 2
    Last Post: 08-22-2005, 06: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