Exporting Excel spreadsheets with functions

G

GiggleSwitch

I have a spreadsheet that is loaded with both data and functions. I
want to save the whole ball-of-wax as a comma-delimited text file that
can be re-imported if necessary at a later date and retain all the data
and math functionality. Where a function is used I want the function
saved to file, not the result value. How do I do that?
 
G

Gary''s Student

Using Find/Replace locate all = signs and replace them all with .=

This will convert all formulae into text strings. Save as .csv When you
later re-import the file, reverse the process and convert all .= into =
 
Top