Put it in quotes? (off the top of my head with no Excel knowledge)
Jerry Johnson >>> [EMAIL PROTECTED] 03/04/02 02:46PM >>> Hi all, I am trying to tell excel that a number is text. I want the zip code to always be formatted with a minimum of 5 digits. I can get cf to tell excel that the number is 01838, but excel always seems to interpret this as 1838. Any ideas on how to fake excel into thinking that it is a string instead of number? Dave ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
