No.

When you ask Excel to insert commas into a number, it will do so in groups
of three before the decimal point. However, Excel thinks your decimal point
is after the cent, not after the dollar. So you would end up with something
like 145,0.06, which isn't what you want.

When the numbers are "pulled into another worksheet" why don't you just
divide by 100, then format normally?

Regards,
Fred

"Sheba" wrote in message
...
I have a workbook where numbers are entered as whole numbers (includes
cents
but no decimal point) on one worksheet. These numbers are pulled into
another worksheet and I need the numbers to have decimal points before the
last two numbers. From another post, I found out I can do this by
formatting
these cells as Custom = 0\.00 . Is there a way to have the comma appear
before the thousands?