| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
Assuming text is in column A
In B1 enter =MID(A1,5,2)&RIGHT(A1,2)&LEFT(A1,4) Copy down. Gord Dibben MS Excel MVP On Wed, 7 Feb 2007 12:20:02 -0800, Renetta wrote: I have a file received via Excel with dates formated as 19840719 I would like it to reflect as 07191984. is there a way to write a formula to change and or change? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| A new Excel add-ins web-site | Links and Linking in Excel | |||
| Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Threaded Mode
