Hi Forum
I have a workbook with a few queries in which I specified every column with the correct data type. The queries are loaded into worksheets.
I want to take these tables and use them in other workbooks (merge with other queries). But here is the problem: If I import the tables PQ forgets...
Hi, I have a very basic question about plotting data in Excel charts.
My data contains two columns representing date and quantity and a third column which contains categorical values (see sample data below). I need to create a simple column chart with date on x-axis and quantity on y-axis and...
Greetings! I have a column in a spreadsheet with cells each custom formatted to display a number (indicating quantity) and a unit of measure (such as lb., kg, can, pc, etc.). I need to separate this column into two formatted as number and text displaying the numeric value for the quantity and...
I'm having with an import that involves number that are sixteen digits long. They appear to come in from Excel in scientific notation and all I need on the Access side is a 16-character string that represents the original number. (I need it to be text because that's the way it will be stored on...
Conditional Formatting cells for text
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
I am new to this so i apologize if this is already posted... What i am looking to do is conditional format a column to look for several things. <o:p></o:p>...
Hi everyone,
I'm using the Currency data type in my current User Defined Function(UDF) Add-In in Excel 2007 VBA to handle monetary values (e.g. salaries). My questions are:
1. So is the Currency data type the BEST data type for handling All monetary values this and if so, why?
2. What are...