Checking formatting in a LARGE workbook
 

Is there a quick and easy way to check formatting within a large workbook?

My workbook has a about 15 tabs and all of them are protected to some
degree. I have noticed that on a couple of tabs in some cells the formatting
is set to "Special" , "Codigo Postal" - Portuguese Postcode!

I want to change the formatting in those cells back to General.
--
Cheers,

Andy

Checking formatting in a LARGE workbook
 

If your using Excel 2003, you might try turning on the macro recorder and doing

Edit=Replace and work with replacing formats.

--
Regards,
Tom Ogilvy



"AndyOD" wrote:

Is there a quick and easy way to check formatting within a large workbook?

My workbook has a about 15 tabs and all of them are protected to some
degree. I have noticed that on a couple of tabs in some cells the formatting
is set to "Special" , "Codigo Postal" - Portuguese Postcode!

I want to change the formatting in those cells back to General.
--
Cheers,

Andy

Checking formatting in a LARGE workbook
 

Thank you Tom,

Sometimes the simplest solutions are the best!
--
Cheers,

Andy


"Tom Ogilvy" wrote:

If your using Excel 2003, you might try turning on the macro recorder and doing

Edit=Replace and work with replacing formats.

--
Regards,
Tom Ogilvy



"AndyOD" wrote:

Is there a quick and easy way to check formatting within a large workbook?

My workbook has a about 15 tabs and all of them are protected to some
degree. I have noticed that on a couple of tabs in some cells the formatting
is set to "Special" , "Codigo Postal" - Portuguese Postcode!

I want to change the formatting in those cells back to General.
--
Cheers,

Andy