Need Help Converting Numbers to Dates
JWNJ wrote...
....
. . . my problem is the installation date is formatted as
yyyymmdd. So, for example, today appears as 20070521. How can I
convert this is appear as 5/21/07, . . .
....
Another formula alternative
=--REPLACE(REPLACE(x,7,0,"-"),5,0,"-")
|