How To Get Excel For Mac

I'm trying to create an Excel sheet to display MAC addresses in the following format - 00:00:00:00:00:00 However. The characters can be either letters or numbers.

I've modified the 'hh:mm:ss' template to accomodate the format I need, but it will not recognize letters for the obvious reason. Is there a wildcard character that I could use in this format or has anyone created a format that would meet my needs? If I can pull this off, it could mean a promotion. Thanks in advance for any and all help. Code: Private Sub Worksheet_Change(ByVal Target As Range) Dim myText As String If Len(Target) 12 Then Exit Sub 'check for correct length If Target.Column 1 Then Exit Sub 'only Column A Application.EnableEvents = False myText = Left(Target.Text, 2) _ & ':' & Mid(Target.Text, 3, 2) _ & ':' & Mid(Target.Text, 3, 2) _ & ':' & Mid(Target.Text, 3, 2) _ & ':' & Mid(Target.Text, 3, 2) _ & ':' & Right(Target.Text, 2) Target.Value = myText 'put MAC string back into original cell Application.EnableEvents = True End Sub • How to use the above code: Press Alt-F11 to open the VBE. Press Control-R to open the Project Explorer.

Office 2016 for Mac versions of Word, Excel, PowerPoint, and OneNote for 1 Mac. I was nervous about buying the Mac download because of all the negative reviews but I didn't want to wait Office for Mac has always been the red-headed step-child at Microsoft. The 2011 version has been good. Buy microsoft word for mac. Office 2016 Home & Student for Mac has the classic Office apps you know, including Word, Excel, PowerPoint and OneNote. Office 2016 is a one-time purchase that comes with fully installed apps like Word, Excel and PowerPoint for PC or Mac, and does not include any of the services that come with. Microsoft Office 2016 Home and Student for Mac comes with the following features You will be thankful when you discover that the Auto Correct feature in Word for Mac has been restored which When you have a Mac but is more familiar with Microsoft Office, get your Microsoft Office Home. The MS Office for Mac Home and Student 2011 edition includes all the essential MS Office software and applications like MS Word, MS Excel and MS PowerPoint. Users can certainly take advantage of this Microsoft Office Application Suite edition for Mac since the package offers the best features that. Find great deals on eBay for Microsoft Word for Mac in Office and Business Software. Shop with confidence. This is a use copy of Microsoft Office Mac Student And Teacher Edition 2004.

You can get to a point where you only crack out the Excel to convert documents to CSV if someone happens to give you an XLSX document. Designing databases is a job in and of itself. The way I learned how to do this was first through school. I took a class with a professor that everyone seemed. Both have the ability to export files as Word and Excel if you need to send files to other people who don't have Macs. Or, you can purchase Microsoft Office for Mac 2011, which contains both Word and Excel.

Click 'Microsoft Excel Objects' for the file you're working on. Double-click the sheet module where you need this to work.

Open the Code pane with F7. Paste the above code in. Press Alt-Q to close the VBE and return to Excel Hope that helps! Assumming your addresses are in column A, starting in row 2 Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column 1 Then Exit Sub 'column of interest If Target.Row 1 Then Exit Sub 'no multiple selections With Target 'ex: ae:12:e0:34:bb:00 Application.EnableEvents = False.Value = Left(.Value, 2) & ':' & Mid(.Value, 3, 2) & ':' & Mid(.Value, 5,2) & ':' & Mid(.Value,7,2)& ':' & Right(.Value,2) Application.EnableEvents = True End With End Sub This goes in the WorkSheet module HTH lenze.