If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|