Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Reformating dates

	98.1 % recommend us
	More live stats...

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

Training information:

Reformating dates

Resolved · Low Priority · Version 2010

Reply Wed 15 Dec 2010, 16:35Delegate Emma said...

Emma has attended:
Excel Intermediate course

Reformating dates

I download date based data from a third party for analysis. The data is US dates and in two different formats 12-01-2010 12/13/2010. I cannot find a way to change these different date formats to one format and then from US date to UK date formats. I have to create a new column and manually add in the dates which takes 40 mins or so!

For upcoming training course dates see: Pricing & availability

Reply Thu 16 Dec 2010, 15:31Trainer Nafeesa said...

RE: Reformating dates

Hi Emma,

Thank you for your question.

To format dates from US to UK:

- Select the date range i.e. A1:A20

- Open the 'Format Cells' dialogue box (right click on data set or Ctrl+1)

- On the 'Number' tab select 'Date' from the category list

- Ensure 'English (U.K)' is set in the 'Locale (Location):' field (towards the bottom of the dialogue box)

- Select the relevant UK date format.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.

Regards,

Nafeesa

Microsoft Office Specialist Trainer

Reply Thu 16 Dec 2010, 15:32Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Reply Thu 6 Jan 2011, 10:10Delegate Emma said...

RE: Will be marked as resolved in 5 days

Thanks Nafeesa - Sadly that has no effect at all in this case.

I tried again with the document saved in both CSV and xlsx format. I have also tried custom dd/mm/yyyy in the past.

Thu 23 Dec 2010: Automatically marked as resolved.

Excel articles

· Want To Create A Presentation In Excel?
· Create Date Sensitive Colour Changing Cells In Excel
· How To Get The Best Out Of Excel With The Internet
· How to Create Better Excel Spreadsheets: Part Two
· A Quick Guide To Conditional Formatting In Excel 2007/2010

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips