saving format

[bob]

i have a spreadsheet that i backup & copy to a new folder but the cell
formulas are replaced with the cell values. how do i keep the formula
format.

thanks

 

[Dave Peterson]

Save two copies???

One with the formulas and one after the formulas have been converted to values.

 

[Gord Dibben]

Or are you saying that when you make the backup copy the formulas are somehow
changed to values automatically and you don't know why?

How are you making the backup if this is the case?

Gord Dibben Excel MVP XL2002