J
J
John Smith2021-07-26 20:16:50
excel
John Smith, 2021-07-26 20:16:50

How to use region-specific formatting in the TEXT function in EXCEL?

I'm trying to use a hard task of the region of the formatting string of the TEXT function in Excel. Tables are used on a PC with Excel under different locales, and the formatting breaks - I want to avoid this.

Example: Source date in a cell, for example, "12/17/2021".
In the English version, the formula =TEXT($O$1;"[$-0419]DD.MM.YY") produces DD44547.MM.YY
In the Russian locale, it behaves predictably normally.

CHADNT?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question