Sunday, February 04, 2007

Time and date

How to quickly enter date and time in Microsoft Excel?

To quickly enter date, press CTRL+;
To quickly enter time, press CTRL+SHIFT+;

This works in all Microsoft Excel versions(97,2000,2003,2007)

The format for date and time would depend upon your regional settings.

You can format your date and time in your own language. To know more,click here

No comments: