Export file problem for TXT file.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Shital shah
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export file from txt (Notepad) 2
Export to txt file using VBA 1
Open txt file without changing date 1
formatting of txt file 4
Problem formatting dates from CSV file 2
Date problems when importing txt files 1
Formatting chart TickLabels fails to include time with date 2
VB: date format in an Excel file 2

Back
Top