data types

Trying to find the exact instrument you care about is an exasperating experience. You type in what you think it is, select Data Types | Stocks and it either reports something wrong or finds nothing. Then on the Stock Selector pane, you type in all permutations you can think of and still comes up...

The new DATA TYPES in Excel for Insiders (Beta at this point) are certainly good fun. But typing in the column title for the data you've extracted from each cell is a right pain. If you wish to select a long list of items from the field selector, you would think that you would be doomed to have...

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...