is there a way to tell a column that if it sees a number it should be
reflected as a minus? I'm doing deposits in one column and checks in
another, with the total in the third. I've got the formulas in place and it
works great---but I have to put a minus sign in every time----is there a way
to avoid that step? Thanks for any light anyone can shed on this---This
discussion group is the BEST---I've learned TONS here!!!

Outlook???

"Bons" <(E-Mail Removed)> wrote in message
news00BE2F5-348F-4DC3-B993-(E-Mail Removed)...
> is there a way to tell a column that if it sees a number it should be
> reflected as a minus? I'm doing deposits in one column and checks in
> another, with the total in the third. I've got the formulas in place and
it
> works great---but I have to put a minus sign in every time----is there a
way
> to avoid that step? Thanks for any light anyone can shed on this---This
> discussion group is the BEST---I've learned TONS here!!!

The formular for that is:

0 - [field]

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 4 Jun 2009 12:01:02 -0700 schrieb Bons:

> is there a way to tell a column that if it sees a number it should be
> reflected as a minus? I'm doing deposits in one column and checks in
> another, with the total in the third. I've got the formulas in place and
it
> works great---but I have to put a minus sign in every time----is there a
way
> to avoid that step? Thanks for any light anyone can shed on this---This
> discussion group is the BEST---I've learned TONS here!!!