Computing.Net > Forums > Office Software > How to display date in dd/mm/yy

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

How to display date in dd/mm/yy

Reply to Message Icon

Name: vhthakor
Date: November 27, 2008 at 00:39:18 Pacific
OS: Windows Xp
CPU/Ram: Intel Core 2 Duo
Comment:

I am using Microsoft Office 2007. But, when I
enter date in excel, it displays in mm/dd/yy
format. I live in India. In India, date is
displayed in dd/mm/yy format.

How can I display date in dd/mm/yy format for
any of the excel sheet ?

Any help, please.

Vishnu



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: November 27, 2008 at 13:45:57 Pacific
Reply:

On the Home tab, go to the Format option, Format Cells.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: How to display date in dd/mm/yy

Excel date format in dd/mm/yy www.computing.net/answers/office/excel-date-format-in-ddmmyy/8378.html

Excel: date from form to worksheet www.computing.net/answers/office/excel-date-from-form-to-worksheet/7817.html

How to Calculate hour in ACCESS re www.computing.net/answers/office/how-to-calculate-hour-in-access-re/6225.html