data type

  1. E

    Fibonacci sequence generator overflow

    Hello, I wrote a piece of code that would generate fibonacci sequence, but there is no data type that can hold such big numbers, is there a workaround to make the code contiune to do the math with big numbers? Thanks. Option Explicit Sub Fibonacci() Dim i As LongPtr, k As LongPtr i =...
  2. DRSteele

    North American Stock Market Indexes with 52-Week Performance Chart

    With the intention to help those struggling to find stock names and symbols for Data Types | Stocks, I put in some effort. I have uploaded to OneDrive a file containing all the stocks in the TSX Composite, the Dow Jones Industrial Average, the S&P500 and the NASDAQ100, current as of December 29...
  3. O

    Field Type Amendment

    Morning, If I amend a field format in the source Excel document, will Power BI be able to refresh the data without errors? Basically I've got a data download from another system and the financial values were stored as text and I need to change them to decimal for a SUM but query editor can't...
  4. B

    change data type of a linked table in access

    I get the below messages in access: Table is a linked table whose design can't be modified. if you want to add or remove field or change their properties or data types you must do so in the source database. I want to change the source data types, how do I do that?
  5. N

    MS Access SQL - data type mismatch

    Hi. While I've been writing Oracle SQL queries for a few years now, I'm relatively new to MS Access SQL. There are surprisingly few resources available online (via Google) for MS Access SQL. Given that, I'm having difficulty figuring out how to format a field which is text as a number (or vice...
  6. D

    Original Fractions in Spreadsheet Don't Convert to Fractions

    Hi guys, I'm having this weird issue in my spreadsheet. I have columns populated with fractions but in excel they are not yet selected as fractions (They are "general"). When I select them and change the data type to fraction, it says its a fraction but there is no change. When I individually...
  7. W

    How to Change Data Type from 1 to 2 (or vice versa)?

    Hi Everyone, I have been trying to join two Excel tables with a Microsoft Query and kept getting the "Type mismatch in expression" error because my data is different types. I tried using Ctrl + 1 to format the cells (text/ general/ number, etc.) but kept getting the error even if they appeared...
  8. R

    MS Access pass-through query for Oracle produces incorrect data type field

    MS Access 2003 Oracle 10g Windows 7 I am basically running data updates every night into local MS Access tables from source data tables in Oracle. This worked fine, until some change on the network which produced a timeout error for all append queries that used pass-through queries. In order...
  9. P

    Which lookup formulas can be used with different types of data?

    Hi all, I'm trying to come up with a simple way to explain to new users in what situations you would use excel's various lookup formulas, to show why it's important to know what format (cross-sectional vs. panel) your datasets are in -- for example, VLOOKUP can be used to pull values from a...
  10. U

    What Data Type do you use for Boolean plus one. True, False and TBD

    I have a complicated routine that I am writing that would normally be Boolean but there are a few times when the answer will be To Be Determined. There are some that are clearly defined with a lot of IF THEN ELSE statements but when all is said and done, there will be three answers. There are a...
  11. F

    What is wrong with my formula code

    Hello all, I'm using the following code to enter a formula into column B which references values in column T: 'Populate Program name column with formulas now referencing values in column-T. Dim ab As Long, c As Long ab = Cells(Rows.Count, "T").End(xlUp).Row For c = 2 To ab Range("B" &...
  12. P

    PowerPivot Show Details creates data table with all fields as TEXT Type regardless of data Type in PowePivot

    I'm new to using PowerPivot but very proficient in Pivot Tables. After I import data from a CSV file into PowerPivot (regardless if data was recognized on import as various types or as all text) I then, column by column, set the Data Types to Decimal, Whole Numbers, Dates, etc as needed and I...
  13. bensonsearch

    VBA Variable type

    Hi All, may be easy but i need a variable type to hold 13 digits in it. I first did long but it aint long enough. It is told hold a barcode.
  14. M

    VBA, ActiveXControls and Data Types

    I am collecting data through an ActiveXcontrol. The command I am using is 'ai = DataqSdk1.GetData'. This data is coming in as type 'variant'. I want to be able to manipulate this data (from counts to a pressure value), but I first need to convert its data type to double. I tried the following...
  15. C

    rota worksheet

    Hi everyone, i dont have in depth knowledge of excel but have been trying to build a rota worksheet from scratch, but i am stuck now. I have a master rota which has everyone's ideal shifts and a weekly rota, i have copied master to weekly so when i put in a time on 1 it updates the other and...
  16. L

    Excel VBA - retrieve Sybase TEXT data type

    I’m having a problem with TEXT Data Type in Sybase. (TEXT is used to store “REMARKS” which may be very long) I have this TEST1 table for testing: create table TEST1 ( DATE datetime, REMARKS text ) [1] I am able to insert some string into the “REMARKS” field but not retrieve it using...
  17. E

    Help With Dates to Text!!!

    I've been looking for answer to this one for awhile. I have a bunch of files with cells that contain a date in the date format (i.e. 10/15/08 stored as "39736" in excel). My task is to create a macro that converts these excel dates to static text in the format yyyy-mm-dd. I've been trying to...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back