>SELECT Vis_PK, Vis_Status, Vis_Start_Date, Vis_Intrastate, Opr_Short_Name, ; > PADR("http://myDomain.com/xdb/Vis" + TRANSFORM(Vis_PK) + ".xdb", 60) AS URL ; > FROM visit JOIN operator ON vis_opr_fk = opr_pk ; > WHERE vis_comprehensive = .T. and ; > Vis_Type = "Inspection" and ; > Vis_Status IN ("Completed", "Finalized") AND ; > vis_inactive = .f. and opr_inactive = .f. ; >ORDER BY vis_Intrastate, vis_start_date > >COPY TO "completed_inspection_list.xls" TYPE xls >>I found it interesting that the URL column did not display in blue or become clickable in Excel. If I edit one of the values, or manually type something that "looks like a URI" it does. Is there a secret to convincing Excel to treat that column as hyperlinks?