ExcelBanter - How do I set up a "roll over" counter in excel 2003?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I set up a "roll over" counter in excel 2003? (https://www.excelbanter.com/excel-worksheet-functions/133634-how-do-i-set-up-roll-over-counter-excel-2003-a.html)

mcorson

How do I set up a "roll over" counter in excel 2003?

Example: I want to count up to 99,999 the next number would be 0.

David Biddulph[_2_]

How do I set up a "roll over" counter in excel 2003?

=MOD(A1,100000)
--
David Biddulph

"mcorson" wrote in message
...
Example: I want to count up to 99,999 the next number would be 0.

All times are GMT +1. The time now is 12:23 AM.