Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Search across sheets in function ADDRESS
  • Sort list dynamically (functions) COLUMN
  • CONVERT function CONVERT
  • Count cells with condition – multiple conditions COUNTIFS
  • Skills Grid Conditional Formatting
  • Formula Beautifier Excel User tips
  • Paste Special Percentage Excel User tips
  • iframe in Excel (XLiFrame) ADDRESS

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

  • Shades of gray Graphics
  • Pixel Excel Drawing Format Cells
  • When Excel tells you to go get some life Excel User tips
  • Expenses calendar, FaCal Basic Math
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Custom fiscal year calendar (CFlex) 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
  • Count Unique COUNTIF
  • Schedule column Basic Math
  • Sum of divide – Array formula Array formula
  • Multiple Dual-Validations COUNTA
  • VLookup Lookup and References
  • Jan8 date format AND
  • Highlight dates dynamically AND
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme