posted on January 21, 2003 06:49:48 PM new
I have found some of the data downloaded from archive to be not usable in excel for generating a report. Specifically if text is mixed in the same cell with numeric data you can't add the column. In the payment column which is called credits if you entered a comment such as a check number, m/o number or any notatition you cannot total the column. All comments and non numeric characters need to be edited out prior to any arithmetic operations being performed.
posted on January 23, 2003 10:23:43 AM new
Hello davebraun,
I am not an expert in Excel functions, but - I believe that there are some functions that will allow you to add numeric values in columns that contain text. Check Excel documentation, the function names are "istext" and "type" - there may be a formula you can use to bypass the text/numeric data issue.
