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/
