Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formating data
After importing banking information in the format "20041126000001", I want
the end result to be of the format "mm/dd/yyyy". The first 8 digits will be used for this, the remainder may be deleted. Thank you for your help. |
#2
|
|||
|
|||
Hi
use the following formula in a helper column: =--TEXT(--LEFT(A1,6),"0000-00-00")) and format this cell as date -- Regards Frank Kabel Frankfurt, Germany "MLH" schrieb im Newsbeitrag ... After importing banking information in the format "20041126000001", I want the end result to be of the format "mm/dd/yyyy". The first 8 digits will be used for this, the remainder may be deleted. Thank you for your help. |
#3
|
|||
|
|||
Hopefully Jan 1 2005 will come in as 20050101XXXXXX, if not this won't
work: First select the column with the dates, then do datatext to column, select fixed width and click next, click between the last day digit (your example after 6) click next, select the right hand column with 000001 and click do not import (skip), select the left hand column and under column data format click Date and YMD click finish Returns 11/26/2004 for me Regards, Peo Sjoblom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |