Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
formating dates previously creat

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating Dates on a previously created document

Formating Dates on a previously created document

ResolvedVersion 2003

Helene has attended:
Word Introduction course
Excel Introduction course

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?

RE: Formating Dates on a previously created document

Hi Helene

Thank 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

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.