That satisfies my needs... thanks guys!

MJ


-----Original Message-----
MJ,

Activecell.numberformat will give you this in the same
way
that you would define it, or in the same way it shows in
the "custom" section of the FormatNumber dialogue box.

For example, format a cell to normal number format to two
decimal places. In the immediate window, type:
?Activecell.Numberformat

it should return "0.00". Change the format to four
decimal
places, check again and it will have changed to "0.0000".

That should get you started.

Cheers, Pete.

-----Original Message-----

Hi...

I was wondering if there is a way for visual basic to
pick
up an Excel cell's format properties like "Category"
(general, currency, percentage, etc.)

Also if the Category is set to "Number", can VB pick up
the "Decimal places" property?

Any help? Thanks!

MJ
.

.