How to recover the data in excel?

Occasional Visitor

key in函數,將資料傳為數字後並存檔,若想要再回復到函數公式查看,可以怎麼用?


I want to know how to recover the function in the excel.


step1. key in the funcion   step2. copy all the data in the cell  step3. paste on the number without function.

Then  I want to back to the step1,  what can I do?

sorry I am not the American,so my writing ability isn't well.




Macros and VBA

1 Reply



Save your workbook as a different file to archive instead of copy and pasting as value instead.