ofcourse.... you only showed a number! ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 02, 2003 11:32 AM Subject: RE: [ cf-dev ] Excel as a datasource Quirk
> hmm, that will freak when its text though? > > -----Original Message----- > From: Tom Smith [mailto:[EMAIL PROTECTED] > Sent: 02 April 2003 11:33 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Excel as a datasource Quirk > > > you could put the number through numberfomat() with no mask... then add the > dash to the beginning - should work I think... not that' I've tested it. > ----- Original Message ----- > From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, April 02, 2003 11:18 AM > Subject: [ cf-dev ] Excel as a datasource Quirk > > > > One of my colleagues has a quirk with CF45 and using Excel as a > > datasource..... he has a set of values which are coming in via the ODBC > > driver for Excel (they are zipcodes) and the problem is this .... > > > > If a Zipcode has the following format - 12345-19874, ColdFusion will treat > > it as a text value, BUT if the zipcode is something like - 902010, > > ColdFusion will treat it as a number and change it to : 90210.00 > > > > Apart from the usual LS functions etc, is there setting in ColdFusion or > > Excel which can prevent this, bearing in mind that its 4.5. > > > > Thanks > > > > Neil > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
