The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,969 other subscribers

Archive for the ‘Office 2010’ Category

« Previous Entries
Next Entries »

Download Earlier Versions of Office: 2010/2013

Posted by jpluimers on 2019/11/18

Not sure how long these will stay valid, but apparently my nl_office_professional_plus_2010_with_sp1_x86_x64_dvd_731121.iso was damaged (I forgot to check the hash) but I could download a fresh one from [WayBack] Download Earlier Versions of Office.

If you cannot find it by product key (I also tried it with a Visio one: worked fine too), then you can use [WayBack] Office 2010 direct link, X16-32250.exe, X16-32213.exe which are archived here:

–jeroen

via: [WayBack] Lost Office 2010 or 2013 CD/DVD? Legally Download Office From Microsoft

Posted in Office, Office 2010, Power User | Leave a Comment »

Language Accessory Pack for Office – Office Support

Posted by jpluimers on 2018/10/29

For my link archive: [WayBack] Language Accessory Pack for Office – Office Support (short-link)

All supported languages for Office 2010, 2013 and 2066/newer versions.

–jeroen

Posted in Office, Office 2010, Office 2013, Office 2016, Power User, Windows | Leave a Comment »

Completely Uninstall Skype For Business (aka Lync) – Skype Community

Posted by jpluimers on 2017/05/05

I don’t need Skype (aka Lync) on all my VMs, for enough reasons (obnoxiously getting in the way even when not configured, downloading updates even though not used, taking up space, etc).

Removing it through appwiz.cpl is more than just a single step. The reason is that Skype can be part of Office and – despite the updates being called Skype – can be listed as the Lync component in Office.

So the removal is as follows:

  1. Run appwiz.cpl
  2. Select the Microsoft Office version you have installed
  3. Right click, then choose Change
  4. Choose “Add or Remove features” then “Continue”
  5. Choose the dropdown left of “Microsoft Lync” or “Microsoft Office”, then click “Not Available” and click “Continue”
  6. Wait for the removal to proceed, then click “Close”

–jeroen

via: Solved: Completely Uninstall Skype For Business – Skype Community

Posted in Office, Office 2010, Office 2013, Office 2016, Power User | Leave a Comment »

Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons

Posted by jpluimers on 2017/01/09

To match dd/mm/yyyy and mm/dd/yyyy column values in columns C (Date1) and N (Date2), I used these formulas in row 2:

Meaning: Column: Formula: Explanation:
Date1Text I =TEXT(C2,”dd/mm/yyyy”) Interpret date text of the original text no matter the Excel settings
Date1Value J =DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2)) Encode the date text to an actual date: dd#mm#yyyy format where # is any separator
DatesEqual K =J2=L2 Are the encoded dates equal?
Date2Value L =DATE(RIGHT(M2,4),LEFT(M2,2),MID(M2,4,2)) Encode the date text to an actual date: mm#dd#yyyy format where # is any separator
Date2Text M =TEXT(N2,”mm/dd/yyyy”) Interpret date text of the original text no matter the Excel settings

 

Learn how to convert text values into dates in Excel. This lesson covers a range of different scenarios to help you. The comments have even more examples.

Source: Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons

Posted in Excel, Office, Office 2007, Office 2010, Office 2013, Power User | 1 Comment »

Deleting Horizontal Lines From Word

Posted by jpluimers on 2016/08/01

Oh man, why didn’t they make a line object out of this…

But if you realize it is a bottom border, then deleting is easy:

The answer is something of a trick, as the horizontal line is not a line (or a graphic), it’s a bottom border.

–jeroen

via: Deleting Horizontal Lines From Word.

Posted in Office, Office 2007, Office 2010, Office 2013, Power User | Leave a Comment »

« Previous Entries
Next Entries »
 
%d bloggers like this: