Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
I
I
Ivan Melnikov2019-02-22 14:23:09
excel
Ivan Melnikov, 2019-02-22 14:23:09

How to make a cell with a date (date type) a text cell in Excel 2013 so that the date is displayed in the same way?

Not a neighboring cell, but the same one!

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Report
V
Vlad, 2019-02-22
@Result007

The same one without the participation of other cells will not work in any way, only the formula in the next cell = Text (cell, format)

Report
P
Pychev Anatoly, 2019-02-22
@pton

only as a macro
in the Worksheet_Change handler

Similar questions
C
CheesR2017-10-10 10:26:37
There is a large database of addresses in Excel, in a format like: "Far street" must be converted to the format "Far street." Are there any functions for this? 1Reply
A
Andrey Sergeev2020-02-26 17:51:09
How to form a pivot table with all values ​​from a cell separated by commas (simple arrays) and their ID dax, powerM or Excel? 1Reply
M
Michael2017-10-11 22:22:13
Does Excel VBA Application.ScreenUpdating affect applications? 1Reply
J
Johnem2020-02-27 17:17:20
How to make a function in Excel from a JS function? 2Reply
D
Dmitry Luponos2020-03-04 19:56:33
Circuit Accounting, how to unload the primary? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question