Jeff: Here's one more trick that came to mind.
Instead of opening the file immediately upon exporting it from Quick Books, try changing the extension from csv to txt. Then launch Excel and try opening the txt file. I tried this and Excel 2003 immediately launched the Text Import Wizard. This wizard allows the user to define delimiters (comma, tab etc.) and also to define the field type, column by column. My test.txt file looked like: 123456789012,9-1987 The wizard first prompted me for file type (delimited or fixed width). I chose delimited. Next, I chose comma as the delimiter. Next, I chose Text as the field type for each of the two columns. Clicked Finish and data appeared correctly. Carol Warman -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Dougherty Sent: Wednesday, March 24, 2004 8:46 PM To: [EMAIL PROTECTED] Subject: Re: PCWorks: Excel/ *.CSV help...(And Quick Books) Hi Carol, Yes that does work...thanks so much for the extra time. ....but... Try entering 9-1987. Transforms it into month/year. Try changing it to anything else and it's not even close. (28734). I'm going to see what the list Marlene sent has to say.. Thank you. Jeff Dougherty www.intrepid-video.com www.tech-repair.net ----- Original Message ----- From: "Carol Warman" <[EMAIL PROTECTED]> Jeff: I tried typing 123456789012 into a cell and, as you said, Excel formats it as "General" and it shows as 1.23457E+11. This is exponential notation. Formatting it with Text after this does not help, as you have deduced. I then tried formatting the cell as "Number" with 0 decimal places and it displays as 123456789012. I think this is what you want. Give it a try and post back with results, please. Carol Warman -----Original Message-----Jeff Dougherty www.intrepid-video.com www.tech-repair.net ----- Original Message ----- From: "Carol Warman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 24, 2004 12:48 PM Subject: RE: PCWorks: Excel/ *.CSV help...(And Quick Books) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On OK...I'm getting a little fed up with this excel program...why is this program designed to change the values? First, I have a database of info that I have to save with the commas to import to their final locations.I can't open them while they are in the CSV extension, because then the values, namely part numbers, will change to some formula. I've asked for help on this a few months ago and no one had a concrete answer for me. Now, I have the option to export my inventory from Quick Books to CSV or PRN. I never heard of PRN, so I chose CSV and what do you know, the parts numbers are changed after the import. I've created a new default template according to the help section and it still does it. Jeff Dougherty ============= PCWorks Mailing List ================= Don't see your post? Check our posting guidelines & make sure you've followed proper posting procedures, http://pcworkers.com/rules.htm Contact list owner <[EMAIL PROTECTED]> Unsubscribing and other changes: http://pcworkers.com =====================================================
