Copying from one spreadsheet to another....

[Austintx1]

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?

 

[JLGWhiz]

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.

 

[Austintx1]

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

 

[JoeMo]

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.