| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to date format
I have a large file imported from another source into Excel (2003) with a
column of dates. The date column format is eg Mar. 09 1963 but some dates only have the year or no date. I want to convert dates to format dd/mm/yyyy or where there is no full date, to return just the year yyyy. Where the full date is available I can convert using formulas or Text to Column, but I have trouble where there is just the year. Is there a method without having to convert manually all the dates with only the year? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
Threaded Mode
