Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
converting date to text
0 views
Skip to first unread message
TB
Jul 16, 2007, 7:12:02 AM7/16/07
to
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"?
06.07.2007 when formatted as date) as the text (and not number) "06.07.2007"?
Help is very much appreciated.
Toppers
Jul 16, 2007, 7:30:02 AM7/16/07
to
=TEXT(A1,"dd.mm.yy")
0 new messages