That's great, you were right. But what I'm trying to do is automate it so
that I don't have to copy any of the forumla or cell for each line. So is
there a way to automate the display so that it will always show "$0.00" and
then when values change, the amount changes. But I don't want to have to
copy the cell manually as the data will be spread over numerous pages and
manual copying would take too long.

"Max" wrote:

"Brett Patterson" wrote:
Problem with that is that I want G* to be the value of E*-F*. So the numbers
are variable, while the columns aren't.

But that's exactly what you should get when you copy down the formula from
G2 ??

In G2: =E2-F2
copied down, you'll get:
In G3: =E3-F3
In G4: =E4-F4
and so on

when you copy down, what are you getting in G3, G4 ?

perhaps calc mode is inadvertently set to "Manual"?
Press F9, does it compute properly now in G3, G4, etc ?

To check / change the calc mode:
Click Tools Options Calc tab
Ensure "Automatic" is checked OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----