Forum home » Delegate support and help forum » Microsoft Excel Training and help » training ms excel advanced - Importing Data
|
|
|
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. |
training ms excel advanced - Importing Data
Resolved · Low Priority · Version Standard
Reply Fri 5 Jan 2007, 10:47Delegate David said...
David has attended:
Excel Intermediate course
Excel Advanced course
Importing Data
I am trying to reformat a text file into an excel file.
I have gone through the wizard and saved the file as excel but how do I change the format of general fields. I have a field that is formatted as General but I want to format it as a Number field so that I can perform calculations. I have tried to change the format of the field but it doesn't accept it?
For upcoming training course dates see: Pricing & availability
RE: Importing Data
Hi David
Thanks for your question.
You might like to try opening your text file in the actual Excel application if not alrady doing this. File, Open change file type to text and opening it. Use the wizard when the data is brought back in. Remove any non number characters like $, spaces etc and try again.
Let us know if this.
Regards
BEST Training
Reply Wed 10 Jan 2007, 10:32Delegate David said...
RE: Importing Data
Hi Tom,
Yes that has answered my question.
Thanks very much.
Regards
David
|