| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting data - re-formating data to "date" format
I have raw data that I export from a site for work and the date comes over as
Internationa ISO however it has no dashes in it to help format. Example it looks like this... 20080302 just straight numbers. i need to convert this to US date format. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis | Charts and Charting in Excel | |||
| Default display format for "currency" data type | Excel Discussion (Misc queries) | |||
| Import HTML data into Excel - data in "1-1" format translates to J | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
Threaded Mode
