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 » training ms excel advanced - Importing Data
training ms excel advanced - Importing Data
Resolved · Low Priority · Version Standard
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?
Fri 5 Jan 2007, 14:17Trainer Tom said...
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
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:Closing Multiple Open Worksheets At OnceWhen multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option. |
