| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHANGE TEXT DATE TO NUMERIC DATE
The following imported data isn't recognized as a dates:
Jul 4 2008 6:30AM Jun 22 2007 5:59PM I have tried both of these formulas found elsewhere in the Excel Community without luck: =DATE(RIGHT(A1,4),LEFT(A1,LEN(A1)-6),MID(A1,LEN(A1)-5,2)) =TEXT(TEXT(A1,"00000000"),"00-00-0000")+0 ........................ I need the month and year only, text to columns work but requires the data to be copied elsewhere first. using "=left" function can provide the month, but the placement of the year varies by 1 character in the middle of the cell, so "=mid" can't be utilized. I have used "=trim" function and tried the "=Datevalue" function also. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Numeric date to text..formatting question | Excel Discussion (Misc queries) | |||
| Resetting cell format from TEXT to NUMERIC and DATE | Excel Discussion (Misc queries) | |||
| how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
| Date showing as numeric value in a text string formula | Excel Discussion (Misc queries) | |||
Threaded Mode
