Copying from one spreadsheet to another....
Results 1 to 4 of 4

Thread: Copying from one spreadsheet to another....
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2013
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Copying from one spreadsheet to another....

    I am copying some formula's from another spreadsheet that has the numbers in "accounting" format. I like using "currency" instead of accounting and changed the cells to display currency. However, when I go back and double-click on the cell to see the formula, the cell changes back to accounting. how do I change this permanently to currency? is it something in the formatting?

  2. #2
    Board Regular
    Join Date
    Feb 2012
    Location
    Florida, USA
    Posts
    10,992
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Copying from one spreadsheet to another....

    Try this. Go to 'Data' on the ribbon. If 'Edit Links is not grayed out, then click on that and then remove links. Then reset your number format.
    Last edited by JLGWhiz; May 11th, 2018 at 07:54 PM.
    Using Windows 10, Excel 2013.
    Any code provided by me should be tested on a copy or a mock-up of your file before applying it to your original file. Some actions generated by VBA code cannot be reversed with the undo facility in Excel. To open the VB editor, press Alt + F11. To run code from the Excel window, press Alt + F8. Please do not attempt to learn everything about VBA in one thread, especially from me. See this link for attaching images: Attachments

  3. #3
    New Member
    Join Date
    Oct 2013
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copying from one spreadsheet to another....

    Thank you for your help. "Edit links" is actually already greyed out. Any other suggestions? Could it be a formatting issue?

  4. #4
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,361
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Copying from one spreadsheet to another....

    Try formatting the cells you will paste to first. Then copy the formula cells and use pastespecial/formulas, so you are only pasting the formulas not the format from the source cells.
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •