Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting text to dates
Hi -
I'm trying to convert a simple value of 7152004 to a date, and can't seem to figure it out. When I format cells to date, I get a long #### response, and I'm not getting that b/c of the column size. I've tried to do DATEVALUE on the cell, but it gives a VALUE! error. Any suggestions? Thanks! |
#2
|
|||
|
|||
In an adjacent cell, use
=DATE(RIGHT(A1,4),LEFT(A1,LEN(A1)-6),MID(A1,LEN(A1)-5,2)) -- HTH RP (remove nothere from the email address if mailing direct) "Jack" wrote in message ... Hi - I'm trying to convert a simple value of 7152004 to a date, and can't seem to figure it out. When I format cells to date, I get a long #### response, and I'm not getting that b/c of the column size. I've tried to do DATEVALUE on the cell, but it gives a VALUE! error. Any suggestions? Thanks! |
#3
|
|||
|
|||
That worked! Thanks!
"Bob Phillips" wrote: In an adjacent cell, use =DATE(RIGHT(A1,4),LEFT(A1,LEN(A1)-6),MID(A1,LEN(A1)-5,2)) -- HTH RP (remove nothere from the email address if mailing direct) "Jack" wrote in message ... Hi - I'm trying to convert a simple value of 7152004 to a date, and can't seem to figure it out. When I format cells to date, I get a long #### response, and I'm not getting that b/c of the column size. I've tried to do DATEVALUE on the cell, but it gives a VALUE! error. Any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions |