ExcelBanter - converting date to text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - converting date to text (https://www.excelbanter.com/excel-worksheet-functions/150345-converting-date-text.html)

converting date to text

How can I convert by using a function a cell that reads the number 39269 (or
06.07.2007 when formatted as date) as the text (and not number) "06.07.2007"?

Help is very much appreciated.

Toppers

converting date to text

=TEXT(A1,"dd.mm.yy")

"TB" wrote:

How can I convert by using a function a cell that reads the number 39269 (or
06.07.2007 when formatted as date) as the text (and not number) "06.07.2007"?

Help is very much appreciated.

All times are GMT +1. The time now is 10:55 PM.