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 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.ecan.govt.nz ********************************************************************** _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
