Hi
have a look at the numberformat property of the range object

--
Regards
Frank Kabel
Frankfurt, Germany


MJ wrote:
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