The 4.41E+09 value means the field is a number and it can't display the complete number in the space. The ### value means the field is either general or text and the column isn't wide enough to display the complete value. If you will autosize your columns, at least the #### value will display correctly. If you change the 4.41E+09 to text, and autosize, it may display correctly also. I would think there is a way to do that programmatically using the Datastation.
^^^^^^^^^^^^^^^^^^^^^^^ James Walker Systems Analyst St Marys Health System Knoxville, TN Ph (865)545-7731 Fax (865)545-3007 ^^^^^^^^^^^^^^^^^^^^^^^ [email protected] 07/15/2010 02:54 PM Please respond to [email protected] To [email protected] cc Subject [talkbws] Working with CSV files I?ve noticed that CSV files, when opened, will modify the displayed value to a more simplified value. For example 4409354237 will display as 4.41E+09 and 05/02/1999 will display as 5/2/1999. Occasionally long values will display as ########. When using Datastation it uses the displayed value instead of the raw value. I thought that putting quotes around each value in the file would force it to treat everything as text but no luck. I can do a workaround but I am hopeful that there is an Excel setting that I can use instead. Chad Kemp Information Systems Analyst Firelands Regional Medical Center 419-557-7874 --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx CONFIDENTIALITY NOTICE: This message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
