+ Reply to Thread
Results 1 to 6 of 6

Data Types in Excel for Office 365

  1. #1
    Registered User
    Join Date
    11-18-2004
    Location
    Chennai, India
    MS-Off Ver
    Excel 2016,Office 365
    Posts
    35

    Data Types in Excel for Office 365

    I am Using Office 365 and subscribed for Insider and I am able to see some insider function like LAMBDA. But under "Data" tab i am able to see only 2 data types - Stock, Geography but seen in youtube videos other data type like Food,Chemistry,Movie etc. Any idea on why I am not seeing this? I am using the most updated version.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Data Types in Excel for Office 365

    Click on the More button to expand.

    data1.JPG

    data2.jpg
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-18-2004
    Location
    Chennai, India
    MS-Off Ver
    Excel 2016,Office 365
    Posts
    35

    Re: Data Types in Excel for Office 365

    Most Certainly I did this and then chose to ask here !! and, seeing in your screenshot something like "Wolfarm"... what is that? Please help to understand.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Data Types in Excel for Office 365

    These are built-in, see this article. I don't use them so I am not an expert.

  5. #5
    Registered User
    Join Date
    07-09-2021
    Location
    Syracuse
    MS-Off Ver
    o365
    Posts
    5

    Re: Data Types in Excel for Office 365

    Hey, what do you exactly mean by the word DATA? Excel has these types of technical data:-


    BYTE 1 byte Number from 0 to 255 for storing binary data
    INTEGER 2 Integer from -32 768 to 32 767.
    LONG 4 Integer from -2 147 483 648 to 2 147 483 647
    SINGLE 4 Numeric data type with float precision to 6 decimal digits
    DOUBLE 8 Numeric data type with float precision with double precision in calculatons
    CURRENCY 8 A number with fixed 4 decimal digits
    DECIMAL 14 Numeric data type with fixed precision and scale (accuracy upto 28).
    STRING Text string. Flexible length or 64 kilobytes.
    BOOLEAN 2 Logical value (true or false)
    DATE 8 The date in the range from 1.1.100 to 31.12.9999
    OBJECT 4 Reference to an object.
    VARIANT 16 Basic type. May contain special value Null, numeric value, text, reference to object or variable array.

    I hope this helps you out .

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Data Types in Excel for Office 365

    Quote Originally Posted by jake.paul View Post
    Hey, what do you exactly mean by the word DATA? Excel has these types of technical data:
    You are listing VBA data types, which is not what the question is about. If you look at the screen shot in post #2 and read the posts you will see exactly what is meant.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Querying an Excel file column with multiple data types using SQL
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-01-2019, 02:31 AM
  2. Excel data types: Stocks HELP
    By Tirrazo in forum Excel General
    Replies: 4
    Last Post: 07-01-2019, 06:22 AM
  3. Replies: 0
    Last Post: 07-28-2014, 05:49 PM
  4. Employee titles matching office types verification
    By jimtheeagle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2014, 08:48 PM
  5. Replies: 1
    Last Post: 10-24-2011, 11:23 AM
  6. Replies: 0
    Last Post: 10-14-2010, 08:22 AM
  7. Merging excel office data into a publisher office project(Australi
    By Shirl in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-16-2006, 04:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1