| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copnvert dates reading as Text to a date format
Excel 2007. A spreadsheet has a whole column with 1200 dates which are
reading as text 01/12/2008. These dates need to be dates not text. I changed the Control Panel Date to read dd/MM/yyyy but it seems to only affect new documents not the existing ones with the 1200 text dates. Any suggestions how I can convert these text dates to a proper date format so I can then customize them to yyymmdd (20081201). The date needs to be in this format to import into a specific payroll program. You assistance would be much appreciated. -- Margy KZN, South Africa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text dates to date format | 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 | |||
| Format text 'dates' to real dates | Excel Worksheet Functions | |||
| Text and dates into one cell without loosing date format | Excel Discussion (Misc queries) | |||
Threaded Mode
