RE: formatting dates

Hi Jenny

Thanks for this question, sorry i did not reply sooner

It is very easy to do what you are looking for all you do is format the work sheet with the date formats you need on whatever cell you want this to apply

When this is done on all the worksheets you want this to effect you then save this as an excel template with the name you wish to give it - after that is done you can open up the template from file and new - and copy all the date cells into the cells and they should be the format you set them to

Hope this helps you jenny

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn