98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data conversion .XLS to .CSV
Data conversion .XLS to .CSV
Resolved · Medium Priority · Version 2002/XP
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
Tue 29 Jun 2010, 09:44Trainer Newson said...
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.
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.
Mon 16 Aug 2010, 13:53Trainer Newson said...
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
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. |
Excel tip:Manually rotating a 3D chartTo manually rotate a 3D chart; |
