Search results

Hi all I have dates like: 1st January 2009 14th January 2009 How can I change them to look like Thursday/01/Jan/2009 In A1 and A2 Thanks in advance Graham

Hi dnlbrky I tried your suggestion and that didn’t work for me. I've decided to use the Hlink function: Function HLink(rng As Range) As String 'posted by Rick Rothstein If rng(1).Hyperlinks.Count Then HLink = rng.Hyperlinks(1).Address End If End Function Then insert # character at...

Hi all I'm new to Access 2010. I've a Excel 2007 wookbook called "Meetings2011" which has a Worksheet called "MeetingsUpdater". It has 4 columns A,B,C,D. Date,Results1,Results2,Results3 In Columns B, C, D, some are cells are just text most have Hyperlinks to Webpages, which have a "Text...