| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date function
Pam,
Assuming your dates are in column A, put the following formula in column B =DATE("20"&LEFT(A1,2),MID(A1,4,2),RIGHT(A1,2)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pam Coleman" wrote in message ... 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. |
| 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
