So what about:

=TEXT(43592,"mm")&"/"&TEXT(43592,"dd")&"/"&TEXT(43592,"yy")

Or reference a cell where you have put your date.

Answer from JvdV on Stack Overflow
🌐
Microsoft Support
support.microsoft.com › en-us › office › standardize-function-81d66554-2d54-40ec-ba83-6437108ee775
STANDARDIZE function - Microsoft Support
The value you want to normalize. Mean Required. The arithmetic mean of the distribution. Standard_dev Required. The standard deviation of the distribution. If standard_dev ≤ 0, STANDARDIZE returns the #NUM! error value. ... Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.
🌐
Reddit
reddit.com › r/excel › format/standardizing text in a cell
r/excel on Reddit: Format/standardizing text in a cell
May 24, 2024 -

Hi! I am hoping someone can help me! I have information in column A of an excel. They are specifically names of companies. I want to standardize the naming convention of these names and then re-import into my software. Is there a way to have a master list of how we want the companies to be named and then it can match that up with the way that they are currently named and then update/change it so that we can re-import into our software with all the names being the same? I'm trying to avoid having to do this manually. Thanks!

🌐
Got It AI
got-it.ai › solutions › excel-chat › excel-tutorial › conditional-formatting › normalize-text
Excel formula: Normalize text
June 3, 2019 - To remove some of the natural complexity of text (strip punctuation, normalize case, remove extra spaces) you can use a formula based on the SUBSTITUTE function, with help from the TRIM and LOWER functions.
🌐
ExtendOffice
extendoffice.com › excel tips › excel formulas › excel formula: normalize text
Excel Formula: Normalize text
Normalize text in Excel using formulas, ensuring consistent formatting across datasets for improved readability and data presentation.
🌐
YouTube
youtube.com › open training camp
How to Normalize Text in Excel - YouTube
How to Normalize Text in ExcelPROPER function in Excel is categorized as a String or Text function in excel. The PROPER function converts the first character...
Published   December 4, 2021
Views   1K
🌐
Stack Overflow
stackoverflow.com › questions › 75346713 › normalize-text-with-excel
Normalize text with Excel - Stack Overflow
This is another good source, it seems this fuzzy logic for O365 is out of the box under Power Query: sfmagazine.com/articles/2021/january/excel-fuzzy-matching · David Leal – David Leal · 2023-02-04 18:20:52 +00:00 Commented Feb 4, 2023 at 18:20 · Add a comment | Sorted by: Reset to default · Highest score (default) Trending (recent votes count more) Date modified (newest first) Date created (oldest first) 0 · If data does not get more complicated than that, try: Formula in C1: =LET(x,TOCOL(A:A,3),MAP(TOCOL(B:B,3)&" ",LAMBDA(a,XLOOKUP(TEXTJOIN("*",0,"",TEXTSPLIT(a,TEXTSPLIT(a,CHAR(ROW(65
Top answer
1 of 2
1

So what about:

=TEXT(43592,"mm")&"/"&TEXT(43592,"dd")&"/"&TEXT(43592,"yy")

Or reference a cell where you have put your date.

2 of 2
1

Unfortunately I don't think it is possible - see the this link

Quote:

Problem: The value in the date_text argument is not in sync with the system’s date and time settings*

If your system date and time settings follow the mm/dd/yyyy format, then a formula such as =DATEVALUE(“22/6/2000”) will result in a #VALUE! error. But the same formula will display the correct value when the system's date and time is set to dd/mm/yyyy format.

Solution: Make sure that your system’s date and time settings (both Short time and Long time) matches the date format in the date_text argument.

I think the only solution is to make sure that your date is in the valid (i.e. recognised by the system) date format before any other function (like DATEVALUE) is applied.

It will be easy to achieve if your function is simply =text(5/7/19,[Windows date format]). You can reference your cell field (e.g. =[@Date]) and format a given cell using an "universal" date format (the ones that start with * sign).

However, if you are combining =text(5/7/19,[Windows date format]) with some other formula (e.g. when you want to display a full sentence like A very important event happened on 5/7/19) then, unfortunately, cell format won't save you here and we're out of solutions. In such case the end user would need to manually modify the date cell in order to make it recognisable.

🌐
The Bricks
thebricks.com › resources › how-to-standardize-data-in-excel
How to Standardize Data in Excel
... If your data in cell A2 is " California ", the TRIM function will clean it up perfectly. In a helper column, enter: ... This formula returns "California", with all the sneaky extra spaces gone.
Find elsewhere
🌐
Alteryx
alteryx.com › home › how to standardize data in excel
How to Standardize Data in Excel
March 3, 2025 - Using your platform of choice, clean and standardize the data with the embedded tools that encompass the entire range of data. For example, in Excel, you can use the STANDARDIZE function, which will return a normalized value (z-score) based ...
🌐
Savant Labs
savantlabs.io › home › a beginner’s guide to standardizing data in excel
STANDARDIZE Function in Excel: A How-to Guide
August 7, 2025 - Because the STANDARDIZE function needs numerical data, any text, blank cells, or symbols used as parameters will result in this error. To troubleshoot this, make sure that the function you’re using has numeric values for the mean, standard_dev, and x. The STANDARDIZE function in Excel does not allow non-numeric characters or text as valid input.
🌐
Rockstar Excel
rockstarexcel.com › home › excel tips blog › how to standardize names in excel
How to Standardize Names in Excel - Rockstar Excel
April 22, 2021 - Here is how you standardize these names in Excel so they’re all in the same format. To convert from separate columns to [First Last] or [Last, First] formats, you can simply use the & function. To convert from [Last, First] to separate columns, use the Text-To-Columns feature, then the TRIM function to remove the leading space from the first name.
🌐
Exceljet
exceljet.net › normalize text
Normalize text - Excel formula | Exceljet
January 22, 2019 - To remove some of the natural complexity of text (strip punctuation, normalize case, remove extra spaces) you can use a formula based on the SUBSTITUTE function, with help from the TRIM and LOWER functions.
🌐
Reddit
reddit.com › r/excel › format text to standardized format
r/excel on Reddit: Format Text to Standardized Format
July 17, 2023 -

I’ve searched everywhere and cannot find a solution to this. I want to format cells to a standard format where the user inputs a short number and the cell displays the text “AB23XXXXXXX.” The standardized portion is the “AB23” with the remaining portion being zeroes (AB230000000) but the result incorporates the input text. First example: user inputs the number “1” and the result is “AB230000001.” Another example: user inputs “23985” and the result is “AB230023985.” The result should always be 11 characters long, begin with AB23 and flex zeroes to fill the gaps.

Any solution is appreciated!

🌐
YouTube
youtube.com › watch
How to Standardize Names in Excel - YouTube
How to standardize names in Excel.Convert between the most common name formats:1. First name and Last name each in their own column.2. Last name, First name3...
Published   April 21, 2021
Top answer
1 of 1
1
  • This code accepts a selection of one cell, up to a column of contiguous cells
  • Copies the range to an array for efficiency
  • Performs all replacements in your posted code in the array
  • Places the updated array back on the selected range

Option Explicit

Public Sub MultiFindNReplace()

    Const LBLS  As String = "Labels to be updated "
    Const xNAME As String = "Name Update"

    Const OUT   As String = " .COM|.COM| INC.|INC.| INC | LTD |,|-|.|'"

    Const R1    As String = " AND|, LA|,LA| LTÉE| LTÉE.| LIMITÉE| LTD.| INCORPORATION|"
    Const R2    As String = " CORP.| CO.| & CO| AND CO| & CO.| CO. LTD| & CO INC|"
    Const R3    As String = " & CO., INC.| CO., INC.| CO (INC)| LTD| INC| SVC| CTR|"
    Const R4    As String = " LIMITED| LIMITED PARTNERSHIP| CO| LT| MD| OD| THE CO LTD|"
    Const R5    As String = " LTEE| LTEE CORP| CORP| INCORPORATED"

    Const RSIDE As String = R1 & R2 & R3 & R4 & R5

    Const L1    As String = "THE | THE|(THE) | (THE)|LE | LE|(LE) | (LE)|LES |"
    Const L2    As String = " LES|(LES) | (LES)|LA |(LA) |(L') "

    Const LSIDE As String = L1 & L2

    Dim inRng As Range, mAr As Variant, allRows As Long, i As Long, itm As Variant
    Dim outArr As Variant, rsArr As Variant, lsArr As Variant, sz1 As Long, sz2 As Long

    outArr = Split(OUT, "|")
    rsArr = Split(RSIDE, "|")
    lsArr = Split(LSIDE, "|")

    Set inRng = Application.Selection
    Set inRng = Application.InputBox(LBLS, xNAME, inRng.Address, Type:=8)

    If inRng.Columns.Count > 1 Or inRng.Areas.Count > 1 Then
        MsgBox "Please select a single (contiguous) column"
        Exit Sub
    End If

    allRows = inRng.Rows.Count
    MsgBox allRows & " rows Selected"

    If inRng.Count = 1 Then     'if only one cell selected force mAr to array
        ReDim mAr(1, 1)
        mAr(1, 1) = inRng.Value2
    Else
        mAr = inRng.Value2
    End If

    For i = 1 To allRows

       For Each itm In outArr   'remove all occurences of "itm"
         mAr(i, 1) = Replace(mAr(i, 1), itm, vbNullString, , , vbTextCompare)
       Next

       mAr(i, 1) = Replace(mAr(i, 1), "&", "AND")  'replace "&" with "AND"

       For Each itm In rsArr    'remove trailing "itm"
         sz1 = Len(itm)
         sz2 = Len(mAr(i, 1))
         If Right(mAr(i, 1), sz1) = itm Then mAr(i, 1) = Left(mAr(i, 1), sz2 - sz1)
       Next

       For Each itm In lsArr    'remove leading "itm"
         sz1 = Len(itm)
         sz2 = Len(mAr(i, 1))
         If Left(mAr(i, 1), Len(itm)) = itm Then mAr(i, 1) = Right(mAr(i, 1), sz2 - sz1)
       Next

    Next

    inRng = mAr                 'place memory array back to range
    MsgBox "Finished"

End Sub

Notes:

  • I moved all hard coded values into constants at the top of the sub for easier maintenance

    (I think I added a couple of them - please check and remove the ones you don't need)

🌐
Microsoft Community
techcommunity.microsoft.com › microsoft community hub › communities › products › microsoft 365 › excel
How to standardize different time formats | Microsoft Community Hub
Hi all, Stuck in a dilemma, unfortunately a report is sent to me with a a date column that has all kind of different formats. Here are the 3 types:Is...
🌐
Parabola
parabola.io › tool › how-to-use-ai-to-automatically-standardize-your-excel-data
Normalize Data In Excel Using AI – Free Template
November 13, 2025 - Set up your data source by creating ... your Excel file. Select the specific worksheets and ranges you want to standardize. Configure any necessary data preparation. Use Parabola's AI standardization tools to define your formatting rules. This step lets you specify how the AI should normalize your spreadsheet data. Apply any additional processing needed, such as number formatting or text ...
🌐
Formula Bot
app.formulabot.com › excel › standardize-function
STANDARDIZE Excel Formula - Function, Examples, How to Use
Use the =STANDARDIZE function in Excel to calculate the normalized value of a data point based on its mean and standard deviation.
🌐
Stack Overflow
stackoverflow.com › questions › 42223923 › how-to-standardize-data-formats-in-excel
vba - How to standardize data formats in excel - Stack Overflow
Case 6: sourceWorkbook.Activate sourceWS.Activate sourceWS.Columns(i).Select Selection.NumberFormat = "YYYY-MM-DD;@" sourceWS.Range(Cells(2, i), Cells(lastrw, i)).NumberFormat = "YYYY-MM-DD;@" For j = startRow To lastrw Step 1 'Assign the header to the first row NewWorksheet.Cells(1, i) = sourceWS.Cells(startRow, i).Value On Error Resume Next textToFormat = CStr(sourceWS.Cells(j, i).Value) d = CDate(textToFormat) finalDate = Format(textToFormat, "YYYY-MM-DD") NewWorksheet.Cells(j - adjustRows, i) = finalDate 'This error handler purpose to handle the header name!
🌐
The Bricks
thebricks.com › resources › how-to-use-the-standardize-function-in-excel-a-step-by-step-guide
How to Use the Standardize Function in Excel: A Step-by-Step Guide
Say you want to standardize the score in cell A2. You'd enter: ... Here, $B$1 and $B$2 are the cells where you've placed the mean and standard deviation, respectively. The dollar signs in Excel help keep these references fixed when you copy the formula to other cells.