Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export file problem for TXT file.
Hi to all & Sharad Naik
Sharad You have given reply but i am not able to figar-out. 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export file problem for TXT file.
This formula will. In cell A1 you have 20050105. In cell B1 put
=CONCATENATE(LEFT(A1,4),"-",MID(A1,5,2),"-",RIGHT(A1,2)) This will result in 2005-01-05 Mike F "****al shah" wrote in message ... Hi to all & Sharad Naik Sharad You have given reply but i am not able to figar-out. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I export an .xls file to Qif file format | Excel Discussion (Misc queries) | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
need to export row as csv file with column e plus .bom as file name | Excel Discussion (Misc queries) | |||
I need to export.xls file to .csv file for fedex address book | Setting up and Configuration of Excel | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) |