I'll try this method. I do beaucoups of downloads. Thanks ----- Original Message ----- From: "Symeon Breen" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Wednesday, February 13, 2008 10:42 AM Subject: RE: [U2] Excel downloads
> Instead of "07748","012345","000123" have ="07748",="012345",="000123" ?? > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming > Sent: 13 February 2008 14:05 > To: u2-users@listserver.u2ug.org > 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: <u2-users@listserver.u2ug.org> > 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: u2-users@listserver.u2ug.org > > 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 > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/