Date format in Indian style

  • Thread starter Bernard Liengme
  • Start date
B

Bernard Liengme

Have you tried changing your Regional Setting (in Control Panel accessed from Windows Start)?
I use a US version of Office but have my Regional setting to dd/mm/yyyy so I can enter dates such as 29/2/2008
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

Hello,

I am trying to get the date format in Indian style... That is dd-mmm-yy. I am unable to set my excel to do that. It always asks me to enter mm-dd-yy. Kindly help

L Krishna Kumar
 
K

Krishna Kumar L

Hello,

I am trying to get the date format in Indian style... That is dd-mmm-yy. I am unable to set my excel to do that. It always asks me to enter mm-dd-yy. Kindly help

L Krishna Kumar
 

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

How to enter a date in DD-MM-YYYY format 2
Date Format Problem. 2
Default date format 4
Date Format 1
Change date format in Excel footer 2
date format 1
date format convert 2
Default date format for dates entered without a year 2

Top