Saving formulas

[michelle_Pagarim]

Hi. I'm new to mac and have been using excel and finding it extremely annoying!! I have been producing a business cashflow and put in formulas to my table (such as adding a total from a different worksheet and using the sum formula etc..). When I save it and go back into it the next day or email it to a friend, the formulas are no longer viewable and now hard numbers, so I can't see how the calculation was done. Anyone know how to keep the formula there (i.e able to view it in the toolbar??)
thanks

 

[Bob Greenblatt]

Make sure the format you are saving the file in is Excel workbook (or one of
the backwards compatible versions if needed). You are probably saving the
file as a text file which will replace the formula with its calculated
value.