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 =====================================================
