Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data conversion .XLS to .CSV
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data conversion .XLS to .CSV
Resolved · Medium Priority · Version 2002/XP
Reply Mon 28 Jun 2010, 12:42Delegate Phil said...
Phil has attended:
Excel Intermediate course
Excel Advanced course
Data conversion .XLS to .CSV
I have some data within excel which contains bank sorting codes. This data needs to be converted into a csv file so that it can be downloaded into another system. The trouble I am having is when the file conversion sees any bank sorting code that resembles a date (for example 09-01-26) it converts it to a date (9 January 2026 or 9/1/2026) rather than keeping it in its original format. Can you please advise of how the format can be retained.
Thanks
For upcoming training course dates see: Pricing & availability
RE: Data conversion .XLS to .CSV
Phil
Can you clarify. I assume when you are saving the file to CSV Excel is changing the bank sorting codes to a date format? To prevent this highlight the cells in question and change them to a text format by going to Format - Cells. In the Number tab select Text. YOU WILL need to Check to see if your other system accepts the sort code in this format or whether it doesn't.
Reply Tue 29 Jun 2010, 14:17Delegate Phil said...
RE: Data conversion .XLS to .CSV
I had already tried this, and it does not solve the problem. The way we are performing the procedure is that we are inputting the data into excel, selecting 'save as' changing the file type to 'CSV (ms-dos) (*.csv)' updating the file name and then saving. During the save process a number of dialogue boxes are shown and the end result is that the data is converted into date format.
Excel is not changing the format, the format is being changed during the save process whilst the file is being converted from excel to CSV.
RE: Data conversion .XLS to .CSV
Sorry Phil
I haven't heard back from you in a while. My apologies for the delay- Is this resolved?
Thanks
Reply Tue 31 Aug 2010, 12:49Delegate Phil said...
RE: Data conversion .XLS to .CSV
No it was not resolved.
The reply I gave on 29 June explained this, and since we could not wait any longer for your reply we have made a work-around and are processing the information differently.
|