Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Multiple-Validations (connected to each other) Data Validation
  • Custom fiscal year calendar (CFlex) Basic Math
  • Links between two workbooks – dynamically using functions INDIRECT
  • Calculate hours between two cells ABS
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Edit directly in cell Excel User tips
  • The Excel “&” bug Excel User tips
  • Excel Limits Excel User tips

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

  • Edit directly in cell Excel User tips
  • Excel Limits Excel User tips
  • The Excel “&” bug Excel User tips
  • Shapes with dynamic output Excel User tips
  • Shades of gray Graphics
  • SimpleANBox Basic Math

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
  • CTRL+Y a mini macro Excel User tips
  • Jan8 date format AND
  • Get 3rd Wednesday of month Basic Math
  • Expenses calendar, FaCal Basic Math
  • GoLast to jump to last cell in a column CELL
  • Limited Ceiling Basic Math
  • Excel Limits Excel User tips
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme