| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formats
I have an csv file which i have imported into excel from our banking software.
The date has been imported as 180406 being 18 april 2006 if i try to format this into a better format i get a completely diferent date. Is there an easy way to format this as i have 500 rows of transactions i need to tidy up? Thank you in advance Hervinder |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| average value from a table | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| search for latest date | Excel Worksheet Functions | |||
| Date formats | Excel Discussion (Misc queries) | |||
Threaded Mode
