Dear experts need your support to resolve my problem
In my specific excel file when I insert a sheet , his format is on auto as date .can we set in general on auto ? please support to resolve my problem .
I suppose you could use a macro to create a new worksheet and put your desired formatting within the macro. Turn on record macro, create the sheet, adjust the formatting, stop the macro. Look at the code, adjust if necessary.