Thread: converting date to text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default 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.


Reply With QuoteReply With Quote