Quote:
Originally Posted by johnph77
The last time I checked (haven't tried it with Excel 2007 yet) saving Excel spreadsheet files in ".txt" format is a can of worms. First, all formulas had to be converted to values and saved in a separate file. Not difficult at all, BUT - if, for instance, you had averages and percentages you wanted to be expressed as three decimal points, the text file wouldn't save it in that form - 1H for 3AB would appear in the text file as 0.3333333333333 (15 significant figures) but 1H for 2AB would appear as 0.5 - a real PITA if you wanted to keep the data in columnar form. Strangely enough, Lotus 1-2-3 was the only spreadsheet I ever found that would do this reliably.
|
I might be misunderstanding you, but I've used the Format Cells function, and selected Custom, and forced it to display as a batting average, and when saved to text it was properly formatted. Am I misunderstanding your post???
P.S. Sorry about the name on the text file, I just opened up excel, did it quickly and saved to text. Feel free to send me warnings or whatever, I should've known better.