Meter Reading Problem

**Dowjd** · 01-02-2011, 02:14 PM

Hey everyone,

I need a formula to calculate meter flow.

Each day I get a flow reading. I must subtract the following days reading to get my daily flow.

The meter may have zeros in the beginning and must have three zeros at the end.

My formula must keep any zeros at the front and add three zeros in the end and the calculate the actual gallons per day.

Here is my example and how I formatted the sreadsheet.

Thanks for the help.

**zbor** · 01-02-2011, 02:20 PM

Right click on cell -> Format cells -> Number -> use 3 decimal places AND thousand separator

(also, since you not here first time it would be nice to state your Excel version in your profile . It won't impact you in any case and it can be helpful for giving solutions).

**martindwilson** · 01-02-2011, 02:35 PM

or change formula to
=(B3-B2)*1000

**Dowjd** · 01-02-2011, 02:42 PM

Originally Posted by zbor

Right click on cell -> Format cells -> Number -> use 3 decimal places AND thousand separator

(also, since you not here first time it would be nice to state your Excel version in your profile . It won't impact you in any case and it can be helpful for giving solutions).

Thanks for the reply. I updated my profile. Using 2003.

I tried your formula, it gives me a decimal point instead of a comma.