data types

  1. shift-del

    Preserve data types

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

    Column chart: Assign/derive column colors by/from data values

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

    Help me separate a number and a formatted text into two columns

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

    Importing large numbers from Excel to Access

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

    Need a Formula to check format of Specific data

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

    How to know if I'm using the right data type?

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

Some videos you may like

This Week's Hot Topics