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?

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)

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)

P

Pychev Anatoly, 2019-02-22
@pton

only as a macro
in the Worksheet_Change handler

Similar questions

R

Rail2016-01-31 23:29:59

Collaboration in an Excel workbook through the "cloud" with access control? 1Reply

L

Lev Kekish2018-06-17 12:40:59

How to add in Excel? 2Reply

N

Nikita Andreevich2021-09-19 17:36:05

How to group the data correctly so that you can then create a pivot based on it? 0Reply

O

Oleg Seledets2018-06-27 23:32:45

How to implement filtering in Excel via Qt? 1Reply

M

McDakk2021-09-25 16:13:09

How to automatically adjust the size or scale of a sheet (print area) in Google Sheets (MS Excel) to a specific paper size? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question