Tech Support Guy banner
Status
Not open for further replies.

Convert Date Format in Excel

1K views 0 replies 1 participant last post by  schlunggi 
#1 ·
I have not found a solutions which worked, datevalue returned #value etc. The basic problem is if your system date is not according to the date format in your text date column. So if you have set it to ISO, starting with the year, datevalue will not work etc.
This procedure worked fianally:

If the date format is like '12/31/2011 (US Format)
1. Change date format in CtrlPanel Regional & Language Option to the corresponding format, in this case mm/dd/yyyy
2. Select column with dates
3. Format Cells General.
Dates will change to Datevalue 40908 (Nbr of days since 01/01/1900)
4. Format Custom i.e. ISO Format yyyy/mm/dd (which really should be used everywhere)
5. Voila 2011/12/31 :)
6. Change date Format in CtrPanel back to your Format
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top