formatting dates

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » FORMATTING DATES

FORMATTING DATES

resolvedResolved · Low Priority · Version 2003

john has attended:
Excel Intermediate course

FORMATTING DATES

HOW DO YOU FORMAT DATES

RE: FORMATTING DATES

Hello John,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding Formatting Dates.

There are several ways you can format a date. The quickest and easiest way is to right click on the cell containing the number or date you want to format, and then choose FORMAT CELLS.

On the NUMBER Tab,m you will see a list of categories on the left. In that list you will see DATE. click on that, and then see the options that become available to you on the right of the interface. Here you can select one of many variations of the date. If you want to switch to another country date format, you can do so by using the drop down menu below the date options on the right of this interface.

If you want to furhter format a date, you can use the CUSTOM Category to format a date specifically, using the following characters as placeholders.

d = day
m = month
y = year

Example:
ddd, d mmm yy
will give you a result like this
Sat, 1 Jun 08

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. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

View all Excel hints and tips


Server loaded in 0.08 secs.