rec.autos.simulators

I've set up an Excel sheet to keep track of my best times and compare
against the 107%, Papy benchmark and Alison Hines' Cooper times, but on the
few occasions when my times are better, and the result of [My
Time]-[Compared Time] should give a negative result, Excel fills the cell
with ###'s. I'm using a custom format for the cells of "mm:ss:oo". Has
anyone else successfully set up their own 'home GPLRank', and if so could
you point me in the right direction?

Thanks in advance,

Rick.

--

Ian P
<email invalid due to spam>

--
The first ever pinball ezboard !!
http://pub7.ezboard.com/bpinball

### is not an error, it's just that the cell is too small.
Just widen the column & it'll display the number properly.

hth, Malc.

The calendar system has to be changed from '1900' to '1904'.

I haven't a clue about what this does, how it does it or why, but it does
work.

Now that's sorted, I've got about 3 minutes to lose from somewhere...

Regards,

Rick.

Did you try making the column slightly wider? Excel does that if the number
displayed is too big to fit into the cell width. A negative number is
"wider" than a positive one due to the minus sign.

You can size the column to fit the data in it by selecting the column and
choosing Format|Column|Autofit Selection