I have a handful of cells in several spreadsheets that contain "=AVERAGE()" and when I try to copy them into another spreadsheet I just copy the function and get "#REF!"
Is there anyway to copy Values? If it matters I'm using csv files.
|
feedback
|
migrated from stackoverflow.com May 23 '11 at 23:01
This question came from our site for professional and enthusiast programmers.
|
Copy them, then Right click -> Paste special, tick "Numbers" and hit enter. | |||
|
feedback
|
