Formating Dates on a previously created document | Excel forum

Resolved · Low Priority · Version 2003

Tue 15 Sep 2009, 16:01 Delegate Helene said...

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?

Thu 17 Sep 2009, 10:10 Trainer Stephen said...

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:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Formating Dates on a previously created document | Excel forum

Formating Dates on a previously created document

RE: Formating Dates on a previously created document

Excel articles

Excel tip:

Generating Random Numbers