how to change date accepting format to day-month-year

M

masc

I would like to enter date in day-month-year in an excel sheet and it should
accept accordingly. can anyone please tell me if you know. thanks in advance
 
T

trip_to_tokyo

I would like to enter date in  day-month-year in an excel sheet and it should
accept accordingly. can anyone please tell me if you know. thanks in advance
Click to expand...

EXCEL 2007

Home / Font group / click on arrow in lower right hand corner / Format
Cells should launch / Number tab / Custom / dd-mmm-yyy / OK

If my comments have helped please hit Yes.

Thanks.
 
G

Gord Dibben

I would change my Windows Regional Short date settings to dd-mm-yy


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extra help on Nth Day of month 1
Excel date question 0
Auto Merge text from multiple sources 0
Add partial year to date 2
How to implement two shifts per day with multiple teams 0
1 Column 'Date' to 3 Seperate Columns 'Month, Day, Year' How?? 0
Creating a Search using a combo box and then creating a report. 4
Remove date format? 3

Top