In response to Karen: It's not an import option issue. A CSV is a member of the Excel class of data files and when double clicking in explorer, Excel opens it and sSays "Welcome home" with no import wizard.
My request is to not have any intervention of the user. They can adjust the columns as necessary themselves as CSV's don't convey column widths although an earlier response gave me the ="0123" suggestion. I'm a little hesitant of putting a formula in front of the data but on the other hand it would only be for those values that are numeric and start with 0. I would not have to use ="Fred" as "Fred" is okay. Thanks ----- Original Message ----- From: "Bessel, Karen" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, February 13, 2008 11:43 AM Subject: RE: [U2] Excel downloads > I have had similar problems with Excel in the past. > > Have you tried importing the column as "text"? > > Sometimes that works & sometimes it doesn't. Excel is a very peculiar > animal indeed. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming > Sent: Wednesday, February 13, 2008 8:05 AM > To: [email protected] > Subject: Re: [U2] Excel downloads > > On this topic, I have a request for a solution. > > In New Jersey, all the zip codes start with '0'. Add product codes like > 012345 and order numbers like 000123 etc and you'll see the leading > zeros. > > When creating and exporting a CSV to eventually be used by Excel, those > columns lose their leading zeros as Excel thinks they are numeric. > > I know that the users can <format column> and choose Custom etc. > > I've converted the same CSV into a HTML boxed record and the zeros > remain as > expected. > > I've tried prepending the values with an astrophe (single quote) to no > avail. > > The true data (as viewed in Notepad) is exactly as I sent it: > "07748","012345","000123" > > So, any tricks in having Excel leave the zeros alone when clicking on > the > CSV in WIndows Explorer. Meaning, that the person opening the CSV in > excel > doesn't have to convert anything. > > Thanks in advance > Mark Johnson > ----- Original Message ----- > From: "David Murray" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, February 12, 2008 4:40 PM > Subject: RE: [U2] Excel downloads > > > > Laurie, > > > > For simple totals, it is possible to add an EXCEL formula into a cell > by > > starting the cell/formula with an '=' sign. This also works with CSV > > structured files, which EXCEL will load and convert on the fly. > > > > Create a virtual/correlative field which will simply output the > formula as > > text and add it to the CSV file e.g. "=SUM(An)". > > > > Cheers, > > > > David Murray > > > > > > .learn and do > > .excel and share > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure > Hansen > > Sent: Tuesday, February 12, 2008 12:10 PM > > To: [email protected] > > Subject: [U2] Excel downloads > > > > Hello, > > > > We are looking for a simple way to drop aggregate totals type reports > > out of Universe into Excel. Our users are using AccuTerm and we also > > have MITS Reports installed. But, neither one does the trick for > > summarized reports that use the DET-SUP option. Having the detail and > > forcing the users to do their own grouping/sub-totals in Excel is > simply > > not an acceptable option here. > > > > UV 10.2.3 on Win2003 server; AccuTerm 2K2 re. 5.1. We also would be > > happy to develop a "simple" (key word...) VB.Net executable that works > > smoothly regardless of the version of Excel, as our users work on > > anything from Office 2000 and above. > > > > Any suggestions welcome. > > > > TIA, > > Laure Hansen, > > City of Redwood City > > Information Technology > > 1017 Middlefield Road > > Redwood City, CA 94063 > > Tel 650-780-7087 > > Cell 650-207-3235 > > Fax 650-556-9204 > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
