SyntaxFix

[excel] Convert date field into text in Excel

You don't need to convert the original entry - you can use TEXT function in the concatenation formula, e.g. with date in A1 use a formula like this

="Today is "&TEXT(A1,"dd-mm-yyyy")

You can change the "dd-mm-yyyy" part as required

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to excel-formula

• Excel doesn't update value unless I hit Enter • Referencing value in a closed Excel workbook using INDIRECT? • Conditionally formatting cells if their value equals any value of another column • Sum values from multiple rows using vlookup or index/match functions • What does an exclamation mark before a cell reference mean? • If two cells match, return value from third • Excel - programm cells to change colour based on another cell • Format numbers in thousands (K) in Excel • Excel Formula which places date/time in cell when data is entered in another cell in the same row • Excel formula to display ONLY month and year?

Examples related to worksheet-function

• WorksheetFunction.CountA - not working post upgrade to Office 2010 • Excel formula to get cell color • How to find the first and second maximum number? • IF statement: how to leave cell blank if condition is false ("" does not work) • Use string value from a cell to access worksheet of same name • I want to compare two lists in different worksheets in Excel to locate any duplicates • Converting a string to a date in a cell • Refer to a cell in another worksheet by referencing the current worksheet's name? • Have Excel formulas that return 0, make the result blank • Convert date field into text in Excel