| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert 20050118 to a working date field
I have exported this field using RIGHT, MID, LEFT, & functions but I am left
with a column that looks like 2005/01/18. I then paste values and when I format as a date it does nothing until I press F2 for each cell. I have many rows, is there an easier way to make the date field usable? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validating a date field | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
| How do I add a date field in a spreadsheet? | Excel Worksheet Functions | |||
| convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Threaded Mode
