by prdfy on Mon Nov 25, 2002 1:58 pm
From my experience, editing and saving a Players.dbf file in Excel 2000/XP will only cause problems if you save the file in Excel format.
When you first click Save in Excel, a dialog box pops up with the following options:
"To keep this format, which leaves out any incompatible features, click Yes."
"To preserve the features, click No. Then save a copy in the latest Excel format."
You want to click "Yes" because you want to save the file in it's original format.
One thing I would like to point out is that changing a value to something that the game cannot handle will cause a crash no matter what program you're using to edit the file. If you look at all the other numbers in the Players'dbf file, none of them have decimal points. So if you're using a formula to change the values and end up with a three or four digit number, who knows how the game will react to it.
Formatting the cells to display no decimal points does not affect the true value of the cell. I always use the =Round() function to get rid of the decimal points and then use Copy, PasteSpecial, Values to get rid of the formulas so all I am left with is a two digit number with no underlying formula.