Excel default format problem

[ali zaib]

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 .

 

[oldbrewer]

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.

 

[Peter_SSs]

See if this is your problem. If so, Ron Coderre has posted a solution there.