+ Reply to Thread
Results 1 to 4 of 4

Copy And Paste Value As Text (Stored As Text)

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    439

    Copy And Paste Value As Text (Stored As Text)

    Hi,

    I am using this code to copy and paste to a destination, but I want the result to be pasted as TEXT, anyone can help?

    Please do not ask me to change the way of pasting because I will have to change the whole macro which is really long.

    Please Login or Register  to view this content.
    Thanks.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy And Paste Value As Text (Stored As Text)

    Hello calvinle,

    The Copy method of the range will copy everything. To make the destination text only, the easiest method is to change the destination format.

    This version of your macro does just that. It checks the number of rows and adjusts the destination cells to that same number and then changes the cell format to text.

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 10-23-2014 at 01:51 PM.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: Copy And Paste Value As Text (Stored As Text)

    Thank you!!

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy And Paste Value As Text (Stored As Text)

    Hello calvinle,

    You're welcome.

+ 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] Marco to convert numbers stored as text to numbers and dates stored as text to numbers
    By a2424 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2014, 10:19 AM
  2. [SOLVED] VBA code to open many files, copy text, close file, paste text in second work
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-11-2014, 12:59 PM
  3. Replies: 13
    Last Post: 11-29-2012, 08:25 PM
  4. [SOLVED] excel paste/numbers not stored as text
    By festival in forum Excel General
    Replies: 6
    Last Post: 07-12-2012, 12:05 PM
  5. Copy and Paste text from a cell to a text box
    By AnthonyJ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2009, 04:18 AM

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