Hi i want to know how to creat date format...i mean i have mention single digit number like 2,but now i want to change like 2/8/2010

Hi,

you must format cell in excel to date format...if you mean excel...

• Marked as answer by Sally Tang Wednesday, September 08, 2010 1:35 AM

Office defaults to picking up the Windows Short Date, which can be configured in Control Panel > Regional and Language.

You can also do it by using a registry file. I'd paste it here, but it doesn't seem that I can access my clipboard, so...

In the Registry, look in [HKEY_CURRENT_USER\Control Panel\International]

Locale
LocaleName
sCountry
sDate
sLongDate
sShortDate
sTimeFormat
sShortTime
sYearMonth

I highly recommend using the ISO 8601 Date Format "YYYY-MM-DD" for many reasons.

Office applications also enable you to supercede the Windows setting or force the standard.
Excel Custom: YYYY-MM-DD or yyyy-mm-dd
Word Field: YYYY-MM-DD or yyyy-mm-dd
PowerPoint: menu-driven with multiple formats