The Wiert Corner – irregular stream of stuff

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

  • My work

  • My badges

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming

    20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now

    20140424-Windows-7-free-disk-space

    More Photos
  • Pages

  • All categories

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

    Join 1,722 other followers

Archive for the ‘Office 2013’ Category

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 »

PowerPoint 2013: when Date, Slide Number or Footer don’t show – via: Academic Technology @ Palomar College

Posted by jpluimers on 2016/07/18

Coming from an Office pre 2000 background, I’m still amazed at how will things are hidden in modern Office versions.

Take the page numbers not showing on slides – Microsoft Community.

I bumped into that recently as well on a new blank presentation:

You see the placeholders at design time, but they don’t show up at presentation time.

The obvious action for me: Right click on each to see if there is anything about special formatting or hiding. It doesn’t work.

What does work is to:

  1. Go to the top of the Slide Masters
  2. Click the Ribbon
  3. Choose Insert
  4. Choose Text
  5. Choose Header & Footer
  6. Put a check marks for the place holders you want to be visible

–jeroen

via: PowerPoint 2013: Date, Slide Number and Footer | Academic Technology @ Palomar College.

Read the rest of this entry »

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

View Headers and Source from Outlook .msg file – via Super User

Posted by jpluimers on 2016/05/23

Sometimes people give you .msg files saved from Outlook instead of forwarding those mails by e-mail.

Opening a .msg file requires Outlook.

You don’t need to bind Outlook to an e-mail account for this (so you can skip those steps when asked the first time Outlook opens). An Office installation that includes Outlook suffices.

After opening the message:

  1. Open the toolbar if it’s not open yet
  2. Under “Move” choose “Actions” -> “Other Actions”
  3. Then choose either “Message Header” or “View Source”

For some HTML messages, “View Source” is not available. I’m not yet sure why.

–jeroen

via: How can I view the entire source code of an email in Outlook 2010? – Super User

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

Improve Word performance with tables

Posted by jpluimers on 2016/03/25

Apart from the obvious “use less tables” and “break tables apart”, these can also help big time:

  1. Run %WinDir%\System32\SystemPropertiesPerformance.exe
  2. Choose “Ajust for best performance” (it will disable all visual enhancements)
  3. Re-enable “Smooth edges of screen fonts” (it will make it easier to set bold and italic apart in Word)

If it is still too slow, I might look into these:

–jeroen

Read the rest of this entry »

Posted in Microsoft Surface on Windows 7, Office, Office 2007, Office 2010, Office 2013, Power User, Windows, Windows 7, Windows 8, Windows 8.1, Windows 9, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Vista, Word | Leave a Comment »

 
%d bloggers like this: