Hey Jeff. Glad to find you found a workaround! Now that we've been round and round on this, I forget why you were saving it as a csv file in the first place. LOL
Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jeff Dougherty Sent: Saturday, September 07, 2002 11:15 PM To: [EMAIL PROTECTED] Subject: Re: PCWorks:*The final frontier** Re: Excell XP revisited, one more time OK..Linda is correct, formatting a new workbook as text will work, but shows a little green diamond in the upper left corner. Formatting as 'general' does not, though it would seem it should as the instructions state no formatting. Now, I found my problem was from the get-go, even though I formatted this thing from the beginning, when I save as CSV then open this one, these values change. The values are converted when I open the new CSV file. If I change the extension of the CSV to TXT before I open it and check the values, they have not changed, so I came to the conclusion opening these up with note pad or Works database the values do not change. Using Excel to open CSV and the values do change. Only problem is, I can't use Works Database to open because there are too many records. In conclusion, I found a work around until I find time to use another program. I appreciate all the responses, so much. So many of you really had the gears turning on this thing for me and you guys are great. IF there are any suggestions now that I pin-pointed my problem, feel free to email me mailto:[EMAIL PROTECTED]?subject =Excel. Jeff ============= 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 =====================================================
