Select the cell you wish to change, then hold down Ctrl button and left-click
on all the sheet tabs you wish the change to affect. Then re-format the cell
as normally done and it will change on all the sheets you have highlighted.

Vaya con Dios,
Chuck, CABGx3



"boyd" wrote:

can i change a cell (say i9:) which is a date in 1-13-02 format to january
13, 2002 format in multiple worksheets within a folder