Also, believe it or not, this works with HTML as well - even the formulas. This gives one great flexibility as one can do shading, font manipulations, borders, column-widths, etc. What I did is create a subroutine CSV.TO.HTML with options for titles, sub-titles, headings and footings. For the titles and subtitles it merges and centers cells using "col-span"...
Craig McDonald Gensco -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Murray Sent: Tuesday, February 12, 2008 1:40 PM To: u2-users@listserver.u2ug.org 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 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/