+ Reply to Thread
Results 1 to 3 of 3

Pasting Value Only

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    St. Louis, Missouri
    MS-Off Ver
    2010
    Posts
    4

    Pasting Value Only

    Hello all,

    So here's my issue: at work we have a online data base to track all of our records for testing. We then export that data to create charts and perform statistics.

    I'm having one problem when a type of value is exported. One of the values are exported as the date it was submitted.
    Example: 3/24/2014 8:16:35 AM. I want to just display the month that it was exported. So in that case, Mar or March. I can do this by custom formatting the cell. However, when I do this, the formula bar still shows the entire date and time (shows 3/24/2014 8:16:35 AM instead of just Mar or March). I need the formula bar to change to Mar or March in order to produce the graphs I want. I thought there was a way to do this by copying the values and "paste values only" or what not but I have yet to come up with a solution. I cannot manually type in the month after each data point because that is simply too much work.

    Thus far I'm thinking that the only way to fix this is to alter they way that we export our data but I'm open to seeing what any of you have to say.

    Thanks!
    -Taniza

    Using Excel 2010.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,739

    Re: Pasting Value Only

    One option is to add a new column and use:
    Please Login or Register  to view this content.
    Then copy, paste special, values back over the original and delete the helper column.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    06-25-2014
    Location
    St. Louis, Missouri
    MS-Off Ver
    2010
    Posts
    4

    Re: Pasting Value Only

    Thanks! That worked!

+ 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: 10
    Last Post: 02-09-2010, 05:04 AM
  2. Pasting into the nth row
    By britta in forum Excel General
    Replies: 2
    Last Post: 09-16-2009, 05:06 AM
  3. Copy+pasting from Firefox vs Copy+pasting from IE
    By srbloom in forum Excel General
    Replies: 0
    Last Post: 02-02-2009, 05:45 PM
  4. Replies: 1
    Last Post: 08-28-2005, 09:05 AM
  5. [SOLVED] Pasting numbers and formulas without pasting format.
    By Dan in forum Excel General
    Replies: 3
    Last Post: 03-26-2005, 11:06 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