I'm working on a spreadsheet to record meter readings from some oil loading
pumps and I've got everything sort ed expect for the following;

The meter numbers we record are 8 digits and when they get to 99999999 they
reset to 00000000, I need a formula which will work out the difference
between the two as if they were carrying on as normal. I.E;
Meter Total Difference
99028990 490500
99519490 490500
00009990 490500

The second thing is that every time I enter a figure starting with 0, Excel
automatically removes the 0 from the beginning which is something I don't
want.

Many thanks for you help

Nathanael