Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel data conversion
|
|
|
Bookmark this page|
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. |
Excel data conversion
Resolved · Medium Priority · Version 2007
Reply
Excel data conversion
I often need to export information into an excel spreadsheet. some ofo the information refers to a client number and these are in the format of 5/1 or 26/3 with the lower numbers, these are automatically put into a date format. How can I put these back into the original format? Normally when I try to change the format it completely changes the number.Many thanks
Polly
For upcoming training course dates see: Pricing & availability
RE: Excel data conversion
Hi PollyThank you for your question. Excel will try and convert values to dates. One way around this is in your source sheet to format the values as Text (select data, right click and choose Format cells. From the number categories choose Text). When the data is brought into your destination sheet Excel will not format the values as dates.
If your source data is a text file use step 3 of the import wizard. The import wizard starts automatically after using File > Open and then choosing a text file containing your data. Step three of the wizard lets you specify the format of the columns of data to be imported. You could set the column containing your client number as text. Excel will leave the client reference alone rather than convert into a date.
I hope this helps - let me know if you have any further questions.
Kind regards,
Andrew
RE: Excel data conversion
Dear AndrewThank you but we cannot change the source data. We only have the ability to manipulate the data once it is in excel.
Or do you mean I should change my standard excel format so the first column will always be text? I am not sure how to do this.
Many thanks
Polly
RE: Excel data conversion
Hi Polly,thanks for your reply. No problem. What format is your source date stored in? Is it text, CSV, Excel or some other type?
Let me know and I will try to assist further.
Kind regards,
Andrew
RE: Excel data conversion
We are exporting our source data from a document management system we use so I am not sure exactly what format this would be stored in, some sort of database I would assume.so 5/1 would become 05/01/1999 or something similar. Would there be a way to convert this back into 5/1? We then print these reports so we just need them to look correct even if they were saved in a format we could not search or sort.
Many thanks
RE: Excel data conversion
Hi Pollythank you for coming back to me. Could you let me know how you get the data into Excel? Depending on the method you use we may be able to ensure Excel doesn't reformat the data.
Kind regards,
Andrew
RE: Excel data conversion
Hi PollyI just wanted to check is this still a problem you are encountering? If so perhaps you could let me know how the data is brought into Excel. This may affect how we can control Excel's behaviour in formatting the values.
Kind regards,
Andrew
RE: Excel data conversion
Dear AndrewThis information comes from a datamanagement system. I have contacted them to find out where the excel template comes from as we see the information and then click to export into excel.
I am just waiting from them to get back to me and then I will let you know. Many thanks for your help so far.
Polly
RE: Excel data conversion
Hi PollyGreat - keep me posted.
Kind regards,
Andrew
|
 |
|
» Forum post: Charts 2007 |
How do i make make my charts look professional?
