Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Links between two workbooks – dynamically using functions INDIRECT
  • Always get 1st name (or last) Formulas - combined functions
  • Standard math to calculate Aspect Ratio Basic Math
  • Dynamic selection list ActiveX controls
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Formula Beautifier Excel User tips
  • Min Max vehicle Formulas - combined functions
  • Count Unique COUNTIF

Excel keeps converting all cells to “Date” (or Time)

Posted on February 14, 2020 By ANmar

Issue found several times in xls or xlsx, to get it fix

https://www.mrexcel.com/forum/excel-questions/637277-excel-converting-numbers-dates.html

Excel User tips, Format Cells, Non-functions, Worksheet Tags:DATE, dormat, time

Post navigation

Previous Post: When Excel functions are not enough
Next Post: Blank (isempty) VS “” (null string)

Related Posts

  • Show developer tab Excel User tips
  • Shapes with dynamic output Excel User tips
  • When Excel functions are not enough Excel User tips
  • SimpleANBox Basic Math
  • Paste Special Percentage Excel User tips
  • Excel sessions – 2013 VS 2010 Excel User tips

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Text-to-Columns, dynamically using formulas IFERROR
  • LastSunday, LastSaturday Date and Time
  • State Abbr with Index+Match+Validation Data Validation
  • Shapes with dynamic output Excel User tips
  • Blank (isempty) VS “” (null string) Excel User tips
  • BMI Calculator Basic Math
  • GoLast to jump to last cell in a column CELL
  • Rotate table using 1 formula ADDRESS

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme