Cell B2 does not work..

[dealbanker]

Hello Does anyone know why the numbers in B2 (total $ matched) does not change? Even after moving to a new race?

I note that when I click on the cell it shows a dollar amount with up to 8 places after the decimal point. The numbers before and the first 2 numbers after the decimal point will remain the same but the remaining 6 numbers after that will change.

cheers

[MarkRussell]

Hello Does anyone know why the numbers in B2 (total $ matched) does not change? Even after moving to a new race?

I note that when I click on the cell it shows a dollar amount with up to 8 places after the decimal point. The numbers before and the first 2 numbers after the decimal point will remain the same but the remaining 6 numbers after that will change.

cheers

Hi,

B2 displays the date that the spreadsheet was last updated.
You need to format the cell as a date.
Right click on the cell and select 'Format cells...' and then select 'Date' from the list of formats.

B3 displays the Total matched.

Regards,
Mark

[dealbanker]

ooops... and so it is Thanks Mark