fine, you're right - I should have read your post more closely... can't help you then. well I could say check the string and see if it is numeric (using isNumeric()) and then if it is, you could use numberformat(), but i guess you already tried that as part of my simple solution? ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 02, 2003 11:43 AM Subject: RE: [ cf-dev ] Excel as a datasource Quirk
> nope, I didnt... 12345-19874 is not a number. > > -----Original Message----- > From: Tom Smith [mailto:[EMAIL PROTECTED] > Sent: 02 April 2003 11:41 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Excel as a datasource Quirk > > > 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] > > -- > ** 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]
