Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Formating Dates on a previously created document
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Formating Dates on a previously created document
Resolved · Low Priority · Version 2003
Reply
Formating Dates on a previously created document
Is there a quick way to format a large document quickly with just one format of a date where two kinds are appearing that has been created by someone else?For upcoming training course dates see: Pricing & availability
RE: Formating Dates on a previously created document
Hi HeleneThank you for your question
Having explored your question I'm afraid I can find not way to carry out the above task using basic Excel Tools.
It is possible to do this by writing a macro which will look at each cell in the worksheet and if it finds a date will format it in the manner required. This is however beyond the scope of the forum
As a result a colleague of mine will contact you to discuss other possibilities
Regards
Stephen
|
 |
|
» Forum post: Naming ranges |
I am having difficulty replacing formulas with names. I have defined the name and they show in the box but when i go to apply the named range it says it can't find a reference. can you help?
