Alan It is entirely certain that you are absolutely correct. Excel does indeed ignore any trailing "0"s. Thanks very much for raising that possibility - I can now pass the issue on to the client with a clear conscience. A good way to end the week. Thanks everyone for their input - especially to Alan for looking beyond the question and testing the reason for the question. Mark On Fri, 24 Jun 2005 13:14:07 +1200, Allan, Samuel <[EMAIL PROTECTED]> wrote:
It is entirely possible that Excel (don't quote me) might simply ignore the superfluous 0, even if it was there, and display it as 32.3, because that is how Excel displays real numbers by default? It may be that the only solution is to get your users to format their Excel spreadsheets after import. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daryl Marsden Sent: Friday, June 24 2005 1:06 p.m. To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List Subject: RE: [DUG] SQL question Mark, I've read a few of the other suggestions and I have 2 general comments which may help. 1. rather than outputting to CSV "print" & format each line to the file 2. CSV=comma separated VALUES. 32.3 IS 32.30. 32.30 is how the value is displayed. If you store irrelevant 0s then the resulting file will be bigger. You could try fixed width field output (requiring even more space?) What is the file to be used for? If input to spreadsheet or database then there should be problem. Daryl Marsden Project Management Analyst Environment Canterbury P O Box 345 Christchurch Phone (03) 365-3828 Ext 7141 Fax (03) 365-3194 http://www.ecan.govt.nz -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Howard Sent: Friday, 24 June 2005 11:23 To: [email protected] Subject: [DUG] SQL question Can anyone suggest a way to return a figure of (say) 32.30 from a SQL SELECT statement, instead of the 32.3? I would like the returned number formatted as I'm just sending the dataset straight out to a CSV file. I'm using DBISAM but I'm willing to try ANY suggestions to see if they work. TIA Mark
-- Forest Production Systems Ltd Creators of PSLog - A harvesting information system www.pslog.co.nz -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.0/27 - Release Date: 23/06/2005 _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
