I'm in the process of transitioning my work office from filing cabinets
full of paper and piles of ledger books to doing everything on the PC.
I am currently keeping records on paper to record the ACTUAL negatives
but not add them to the total. Once I can make Excell record the
negative fractions but not subtract them from the running total I can
stop using notebooks to keep records.

I need to keep a running account tally where all positive and partial
dollar amounts are added the the tally but only whole negative numbers
are subtracted (not fractions).

Example: starting balance is $1.00 and the next entry is -$0.90, the
new balance should still be $1.00

Photo 1 shows how my worksheet looks now and photo 2 is how it should
look.

[image: http://home.comcast.net/~johndoe_69/photo1.gif]
[image: http://home.comcast.net/~johndoe_69/photo2.gif]

Every time I think about how I keep records I picture Ebenezer
Scrooge's office with Quill pens and layers of dust everywhere. :)

Any help would be appreciated, thanks in advance, - John Doe 69


--
John_Doe69
------------------------------------------------------------------------
John_Doe69's Profile: http://www.excelforum.com/member.php...o&userid=33439
View this thread: http://www.excelforum.com/showthread...hreadid=532524