Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Count cells with condition – multiple conditions COUNTIFS
  • Shapes with dynamic output Excel User tips
  • Cells with additional spaces AND
  • Multiple Dual-Validations COUNTA
  • Get monthly total from table with dates DATE
  • Hello world! Uncategorized
  • State Abbr with Index+Match+Validation Data Validation
  • MID + SEARCH to convert cell to rows MID

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

  • Comments versus Notes Excel User tips
  • Recover the unrecoverable Excel User tips
  • Spreadsheet Compare application Excel User tips
  • Stale values (Scratched functions) Excel User tips
  • Custom fiscal year calendar (CFlex) Basic Math
  • When Excel functions are not enough Excel User tips

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Week number to Sunday date – Weeknum reverse DATE
  • Excel Limits Excel User tips
  • CHOOSE – tree of decisions CHOOSE
  • Worksheet name, dynamically using formula CELL
  • Excel ad from early 90s Non-functions
  • Convert cell into textbox Excel User tips
  • Search across sheets in function ADDRESS
  • Sort list dynamically (functions) COLUMN

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme