| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
date function
Are those yy-mmdd
If yes and yy are all in this century, you could use a helper cell and this formula: =--TEXT(--SUBSTITUTE(A1,"-",""),"\2\000\/00\/00") format as date and drag down. Pam Coleman wrote: If I have dates listed in a column as 06-0101 etc, how can I format it to be: 20060101? I have 7000 rows where I need to reformat the date. Help. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date function in Excel that updates only when a doc is changed? | Excel Worksheet Functions | |||
| Date Function | Excel Discussion (Misc queries) | |||
| date format and the RIGHT function | Excel Worksheet Functions | |||
| Date function | Excel Worksheet Functions | |||
| Is there a function to show future date | Excel Worksheet Functions | |||
Threaded Mode
