| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify general format to date format.
When importing from payroll, it gives me all dates formatted as general
numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to convert these numbers into dates? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify general format to date format.
If your Windows Regional Settings recognise a format of mddyyyy, you can
apply the below formula and format the formula cell to date.. =--TEXT(A1,"00\-00\-0000") -- Jacob (MVP - Excel) "SherryS" wrote: When importing from payroll, it gives me all dates formatted as general numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to convert these numbers into dates? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify general format to date format.
=--TEXT(A1,"00-00-0000")
"SherryS" wrote: When importing from payroll, it gives me all dates formatted as general numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to convert these numbers into dates? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Format Change: General to Date | Excel Discussion (Misc queries) | |||
| Change General format to Date format | Excel Discussion (Misc queries) | |||
| Date format for general formatting | Excel Discussion (Misc queries) | |||
| General Format to Date Format | Excel Discussion (Misc queries) | |||
| Change general format to US date format | Excel Discussion (Misc queries) | |||
Linear Mode
