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
|