+ Reply to Thread
Results 1 to 2 of 2

Copy from Excel - maintain formatting of text / numbers

  1. #1
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Copy from Excel - maintain formatting of text / numbers

    I tried to copy from word using VBA.

    In excel I have formatted the values like dates as Nov 20 but when it gets pasted to word it changes back to 1-Nov-20

    How do i maintain the text formatting on word OR copy from excel as values
    Last edited by saravnepali; 09-10-2020 at 07:19 PM.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  2. #2
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Copy from Excel - maintain formatting of text / numbers

    Attaching sample files will probably help.

    The Excel file with the code used to copy, and the Word file, both stripped of all sensitive data.

    I've inserted dates from Excel into Word bookmarks without problems and just the way date was formatted in Excel. I don't see why copy / paste would get different dates in Word.
    To show your appreciation
    Click ★ Add reputation!

+ 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: 02-27-2017, 09:17 AM
  2. Maintain table formatting
    By adamg6 in forum Excel General
    Replies: 0
    Last Post: 10-17-2016, 05:32 PM
  3. Maintain Pivot Chart Formatting (Excel 2010)
    By carlyman in forum Excel General
    Replies: 1
    Last Post: 06-10-2011, 03:22 PM
  4. Replies: 0
    Last Post: 05-22-2006, 04:45 PM
  5. Insert a line and maintain formatting
    By Daniel in forum Excel General
    Replies: 2
    Last Post: 12-04-2005, 05:35 PM
  6. How can I sort and maintain formatting?
    By littlelostgrl in forum Excel General
    Replies: 2
    Last Post: 08-24-2005, 03:11 PM
  7. Replies: 2
    Last Post: 06-28-2005, 11: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