The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » learning excel - Date format

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

learning excel - Date format

Resolved · Low Priority · Version Standard

ReplyThu 23 Nov 2006, 11:12Delegate Lisa said...

Date format

In my spreadsheet I need to list dates. Is it possible to have the date as 23/11/06 instead of 23/11/2006. The main reason is the spreadsheet has 13 columns in total and includes six with dates. If the date can be shortened I would be able to have another column when printed in lanscape.

Please help.

For upcoming training course dates see: Pricing & availability

ReplyThu 23 Nov 2006, 12:05Trainer Tom said...

RE: Date format

Yes Lisa

All that is required is for you to change the format of your date cells in the column

Select the column right click go format cell from the Number tab in the dialog box that pops up under Category select Date under Type box select your desired date type ie. in your case 23/11/06.

Hope this helps. Thank you for using BEST Training Support forum. Feel free to recommend our forum to collegues for friends.

Regards

BEST Training

Excel articles

· So what's new in Excel 2007?
· How to Create Better Excel Spreadsheets: Part One
· Sorting Out Your Data In Excel
· Employing Cell References in Excel
· How To Use Slicers In Excel 2010

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

Ho do you group dates in a pivot table in Excel 2007

» Forum post: Pivot Table

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions