have you tried expanding those columns, excel will put ####'s in place of text that is too large to show in the column view :)
...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:38 PM To: CF-Talk Subject: conversion problem SOT New problem with my csv process... I've got one column that occasionally spits out bad text - I start with an Excel spreadsheet, convert the column format to "TEXT" and save it as a CSV file... When I convert it all looks fine... When I close it and reopen it, the field on SOME rows has all POUND SIGNS in it - all the text is gone.. WHAT could possibly cause this? It's not all rows that have text in that column - only some. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

