| 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! |
| 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 | |||
Threaded Mode
