The reason I ask (and this is for excel specifically) is that if you check a field that you've formatted to text, Excel actually puts a single quote in front of the value (you can see it in the contents of the cell in the bar at the top of the spreadsheet. I thought if you used one over the other (which is the "native" Excel one), that you wouldn't have to strip it out in Excel, since it would already "hide" it...
> > That's what I do for UPC codes... (Stick a single quote in front). > > > > Or do you mean ' vs ` ? > > > > Does one work different than the other when importing into Excel? > > I'd use the standard apostrophe, not the back one, but you can use any > character that's easy to strip off (if you don't want to use Excel) > > It's only Excel that does the annoying number stuff > > Philip Arnold > Technical Director > Certified ColdFusion Developer > ASP Multimedia Limited > Switchboard: +44 (0)20 8680 8099 > Fax: +44 (0)20 8686 7911 > > www.aspmedia.co.uk > www.aspevents.net > > An ISO9001 registered company. > > ********************************************************************** > 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. > ********************************************************************** > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
