+ Reply to Thread
Results 1 to 6 of 6

Copy and paste data changes from number format to date format

  1. #1
    Forum Contributor
    Join Date
    06-04-2014
    MS-Off Ver
    2010, 2013
    Posts
    225

    Copy and paste data changes from number format to date format

    Hi Folks,
    I have a problem with copying and pasting certain types of data onto an excel spreadsheet.
    For example when I copy the following data
    26 - 14
    21 - 11
    19 - 12
    16 - 12
    15 - 14
    14 - 15
    15 - 20
    9 - 7
    11 - 16
    9 - 22
    12 - 24

    and paste it onto the set of cells / column, it changes to this:
    26 - 14
    21 - 11
    19 - 12
    16 - 12
    15 - 14
    14 - 15
    15 - 20
    7-Sep
    16-Nov
    22-Sep
    24-Dec

    I cannot get it to format itself back to the original format from the document I copied from.
    Any help with the formatting trick to change the data back to the original format will be appreciated.
    Thank you
    Attached Files Attached Files
    Last edited by Doofus1; 10-02-2019 at 09:14 PM.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,841

    Re: Copied data changes from number format to date format

    If you're copying cells formatted as TEXT into blank cells, it should automatically copy the TEXT formatting... unless you are using the PASTE VALUES option, in which case it would revert back to GENERAL and convert to DATE format. You can try formatting the destination cells as TEXT before pasting the data into them... just a thought?

    - Moo

  3. #3
    Forum Contributor
    Join Date
    06-04-2014
    MS-Off Ver
    2010, 2013
    Posts
    225

    Re: Copied data changes from number format to date format

    I tried that - and it works however, there are other numbers in that sequence, and once I do that, I cannot, for example do an auto sum calculation

    14 6 3 0 2 1 26 - 14
    12 5 4 1 0 0 21 - 11
    11 5 3 1 1 0 19 - 12
    11 6 2 1 2 1 16 - 12
    10 5 3 1 0 1 15 - 14
    8 6 2 2 0 2 14 - 15
    7 6 1 3 2 0 15 - 20
    5 3 1 1 1 0 9 - 7
    3 5 0 2 0 3 11 - 16
    3 5 1 4 0 0 9 - 22
    3 6 0 4 1 1 12 - 24
    Auto Sum feature does not work of the number sequences in column A, B, C , D, E and F.
    Thank you

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,102

    Re: Copy and paste data changes from number format to date format

    After copying the data from post #3 into column A I used the test to columns feature > fixed width (manually place the partitions)> set the last group to text.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Forum Contributor
    Join Date
    06-04-2014
    MS-Off Ver
    2010, 2013
    Posts
    225

    Re: Copy and paste data changes from number format to date format

    Thank you.
    Sorry about the extremely late response.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,102

    Re: Copy and paste data changes from number format to date format

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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