I have an excel file that I'm trying to put on our MYSQL server, but in this file there is a column whose values come from subtracting the values from one column from another. I'm trying to figure out how to make this column a permanant value so I can upload it, but I'm not familiar enough with Excel to figure out how to "finalize it" (or whatever the term would be) so that the final value is uploaded. Thank you in advance for your assistance! Ian
Here is what I typically do in these situations: Highlight all cells on the sheet (click the grey box between row 1 and column a). Copy this selection. Start a new workbook (or move to a new worksheet). Click the same box in the new sheet (right click and choose Paste Special). On this dialog, change the Paste selector from All to Values. Click okay, and save the new workbook. Cheers!