Try this:
=CONCATENATE("","01234")
For any values with leading zeroes.
Marv
Marvin R. Fisher
Technical Resource Group
A Pipeline Group Company
2850 Red Hill Ave.
Suite 110
Santa Ana, CA 92705
Tel (949) 296-8380 ext. 620
Fax (949) 756-0029
Pipeline Software Statement: This email message is confidential and may be
legally privileged. The contents contained within, including any attached
files, are intended solely for the addressee(s). Access by anyone other than
the addressee(s) is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action, taken or not taken, in
reliance on it, is prohibited and may be unlawful. If you believe that you have
received this email message in error, please contact the sender. Any views
expressed within are those of the individual sender, except where the sender
specifies and with authority, states them to be the views of Pipeline-Software,
Inc., Santa Ana, CA.
(The contents of this email message have been scanned for the presence of
computer viruses.)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: Wednesday, February 13, 2008 6:05 AM
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/
