Power Query Zoom

I used this today in a live webinar.

I zoomed into the Power Query window in Excel to make it easier to see.

Ctrl + Shift + + (plus)

One Minute to Excel #18 – Convert real numbers to text numbers

Two techniques

When you are working with text numbers in tables sometimes you need to convert real numbers into text numbers to do look ups.

There are at least two ways to do this.

Let’s see how to convert real numbers into test numbers, real fast.

May the fours be with you

Excel and Star Wars combine

On the weekend Sunday the 5th of September 2021 is a big day for Excel.

In Excel the date system starts on 1/1/1900 – that was day 1, and each day since has its own sequential number.

On Saturday September 5, 2021 (Father’s day in Australia) that number is – wait for it – see the image below.

May the fours be with you!

If you remove the formatting from a cell  with a date you will see the underlying number.