To insert the current time into the cell that is currently selected in Excel, simply press Ctrl + Shift + ; (semicolon)

This is the time as at the time of writing and it does not upadate.

This is great when you have a report you want to email on a regular basis. It is VBA code but you don’t need to know how it works, just how to adapt it to your needs.

First, Open the file you want to send reports from. Copy the code below and then press Alt+F11. This brings up the VBA editor. Paste all the code into a new module. You can run the macro from the Tools menu or create a button to run it.
I have created an example for you to play with. Click on the title above to see all the code.

Function RangetoHTML(rng As Range)
' Changed by Ron de Bruin 28-Oct-2006
' Working in Office 2000-2007  Read more »

I often want to present a date in the why I think suits the reader rather that the options given in Excel.

Luckily, Excel gives the ability to customise all formats. I wanted to show the date in the following format: Sun 4 May 08. By selecting the Custom option from the Format cells dialogue I was able to change the format type to ddd d mmm yy.

By using the letters ddd, my date will show the three letter version of the day, i.e. Mon, Tue etc. If I used dddd, the full day name would be shown. The month works in the same way, m will give 1 digit, mm will give 2 digits, with a leading zero for months earlier than October. mmm will give the three letter version of the month and mmmm will show the full text of the month. Years have only two options y and yy show the 2 digit version of the year, yyy and yyyy give the four digit version of the year.

If you date format is too long for the cell and you don’t want to make the cell wider, then you should convert the date to text by using the TEXT() function. Try this example =TEXT(TODAY(),”dddd d mmmm yy”) where TODAY() will give you today’s date.