| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export file from txt (Notepad)
Hi to all
I have open exported file of notepad (TXT Format) Where i have data like date, item,amtin,amtout,bal. where data format is DD-MM-YYYY (05-01-2005) the problem is when i conver this data from text to column, date comes in number format like 20050105. is there any way i can put seprater(-) after 4 character and than after 2 charcter (like 2005-01-05 ) any help Thanks ****al shah |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing from a Notepad file | New Users to Excel | |||
| Notepad or .txt file to excel | Excel Worksheet Functions | |||
| Writing to notepad file | Excel Discussion (Misc queries) | |||
| Export notepad file to Excel | Excel Discussion (Misc queries) | |||
| copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
Threaded Mode
