Thread: Meter Readings
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.newusers
Maria Tracey
 
Posts: n/a
Default Meter Readings


"Sandy Mann" wrote in message
...
Tracy,

Daddy doesn't seem to be around a the moment. I would suggest making the
meter reading entries text by formatting the cells as text *before*
entering the reading or preceding them with an apostrophe if they are
already entered, (so that the leading zeros will be counted as
characters), then using Daddy's excellent formula, modify it to:

=MOD(D2-C2,10^LEN(D2))


Thanks, I'll give it a try.

What about the multipliers and dividers ?
Any idea how to tackle that ?