+ Reply to Thread
Results 1 to 5 of 5

Date Formatted as General then pasted into Excel Table in Actual Date Format

  1. #1
    Registered User
    Join Date
    05-28-2009
    Location
    Oxford
    MS-Off Ver
    Excel 2007
    Posts
    86

    Date Formatted as General then pasted into Excel Table in Actual Date Format

    This is really simple but really confusing.

    I have a list of dates in one excel workbook in General Format (I have no choice about this as it's a system export). I want to paste them into another workbook that contains a table. Now usually I thought that new data into an Excel table would take on the properties/format of the existing data in the table. However the dates during this paste look as though they have converted in the format dialogue but actually remain as General no matter what I do.

    The only way I can get them to act as dates once in the table, is to use Text-to-Columns but this is not a practice I want to introduce for people using the sheet.

    Am I missing something dead obvious?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Date Formatted as General then pasted into Excel Table in Actual Date Format

    After the copy process use paste special>>Values and check

  3. #3
    Registered User
    Join Date
    05-28-2009
    Location
    Oxford
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: Date Formatted as General then pasted into Excel Table in Actual Date Format

    Is there no other way to make it automatic? The people using this will never remember to do that.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Date Formatted as General then pasted into Excel Table in Actual Date Format

    I don't have any other suggestion other than this

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Date Formatted as General then pasted into Excel Table in Actual Date Format

    You could temporarily change the formatting of the source data to the date format that you want (formatting is just a visual presentation of the underlying data). Copy this data then at the destination Paste Values and Number Formatting. Then on the source data, click undo to undo the temporary formatting applied. This works with tests that I have done here.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Converting data general column to UK Date format in Excel 2007 - vba
    By Sailaja A in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2013, 06:59 AM
  2. [SOLVED] COnverting an incorrect date format to an actual date
    By Stuwork in forum Excel General
    Replies: 3
    Last Post: 10-24-2012, 06:16 AM
  3. [SOLVED] Convert a general format string to calendar date in Excel 2010 vba?
    By Kuriakos in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-18-2012, 11:44 AM
  4. Date formatted as general makes false statement
    By leem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2011, 08:01 PM
  5. General formatted to Date Format
    By Willih in forum Excel General
    Replies: 1
    Last Post: 09-16-2010, 06:46 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