Assuming you will never have a formatted amount of one million dollars or
more, try this Custom Format...

[<100000]0\.00;0\,000\.00

--
Rick (MVP - Excel)


"Sheba" wrote in message
...
This custom number format really helped me. Now, is there a way to add
the
comma dividing the thousands? #,###.##

"Brett" wrote:

You could create the custom number format 0\.00
That would easily display 12345 as 123.45, but then if you need to
reference
the value in a formula you will have to divide it by 100 in the formula.

"mlou" wrote:

from the tools menu, i clicked options, edit and "fixed decimal" to
two.
However, I don't want this to affect the whole worksheet, just one
column.
is there a way to do that?