How to recover the data in excel?

Copper Contributor

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.

 

 

Excel

Macros and VBA

1 Reply

@laimei 

 

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