Ron,

YOU ARE THE CONSUMATE ADVISOR and I cannot thank you enough for your
guidance! The "totals" in the individual cells now work explicitly how I
would like for them to as long as I format each of them per your direction.
It would be nice if the actual number, entered without the decimal point,
displayed as such but, this is what I need for the cell's results to be.
Maybe you can give MS a nudge to see that this happens in an upgrade soon.

Thank you so much in solving a problem that has baffled me for months! You
are correct in that the display while entering the cell's various additive
values does not display the auto decimal but displays the results correctly
when "Enter" is pressed.

I can't thank you enough. Have a great evening and thanks for being on
board to help us get the full power from Excel!

Warmest regards,
John Couch


"Ron Coderre" wrote:

I understand what you want....but, let's talk about what Excel can do
(without custom programming), OK?

Try this:

Select the input cells
Then...from the Excel main menu:
<format<cells<number tab
Category: Custom
Type: 0\.00
Click the [OK] button

What that will do is display any number with a "decimal point" 2 places to
the left of the actual decimal point.

Examples:
A1: 100...........displays as 1.00
A2: 101...........displays as 1.01
A3: =100+201+305........displays as 6.06

Just keep in mind that the displayed amount is NOT the actual amount. Other
cells that refer to the custom formatted cells will need to divide those
cells by 100 to convert them to the displayed value.

I hope that makes sense.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"John" wrote:

I want to add dollar amounts in an individual cell with a fixed decimal
point. In other words, click on a single cell, press =, then enter multiple
numbers (preceeded or followed by the + or - sign) without having to enter
decimal for each amount entered.

I have worn myself out trying to format a cell to perform this way but
haven't conquered it yet. Even though it works fine when entering a single
number in a cell, it doesn't work when entering multiple numbers this way in
a single cell. As soon as I press = in the cell, all numbers display without
a fixed decimal point. I have to enter it manually and do not want to have
to do so.

Thanks in Advance,
John Couch