Numbers Change to Dates in Excel

Numbers Change to Dates in Excel

Have you ever copied football scores, such as 3-2, and pasted them into Excel, where they magically transform into dates? It's certainly annoying when a nice list of numbers change to dates in Excel, but fortunately there's an easy way to prevent that from happening.

(adsbygoogle = window.adsbygoogle || []).push({});

Continue reading Numbers Change to Dates in Excel

Create an Excel Hyperlink With Drag and Drop

create an Excel hyperlink with drag and drop

In a big Excel file, it's handy to have hyperlinks that take you from one sheet to another. Maybe you need a table of contents, or a single link on a summary sheet that takes you to a data entry sheet. You can use the Insert Hyperlink command on the Ribbon, but it's even quicker to create an Excel hyperlink with drag and drop. Here are a couple of ways to do that.

And there are a couple of Excel announcements too.

(adsbygoogle = window.adsbygoogle || []).push({});

Continue reading Create an Excel Hyperlink With Drag and Drop

Excel Roundup 20160321

Excel Roundup http://blog.contextures.com/

In this week's roundup, Data Analysis, Power BI, combining functions, and more Excel tips.

NOTE: There won't be an Excel Roundup next week (March 28th), due to the Easter Monday holiday.

Continue reading Excel Roundup 20160321

Excel Roundup 20160314

Excel Roundup http://blog.contextures.com/

Happy Pi Day! In this week's roundup, troubleshoot large Excel files, free webinars, reporting tips, and much more.

Continue reading Excel Roundup 20160314

Excel Roundup 20160307

Excel Roundup http://blog.contextures.com/

In this week's roundup, Power Map, Excel formula errors, cell references, and more.

Continue reading Excel Roundup 20160307

Excel Roundup 20160229

Excel Roundup http://blog.contextures.com/

Happy Leap Year Day! According to my calculations, the next time that Leap Year Day falls on a Monday will be in 2044. By then, Excel will be 58 years old. Do you think that Excel will still be around, or will it have retired early?

This week, cool tricks with the new TEXTJOIN function, tell a story with your charts, create a calendar for Power Query, and more.

Continue reading Excel Roundup 20160229

Excel Roundup 20160222

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, Slicer trick, pivot charts, slow workbooks, dashboards, and more.

Continue reading Excel Roundup 20160222

How to Split Date and Time in Excel

How to Split Date and Time in Excel http://blog.contextures.com/

If you download data into Excel, one column might have a combined date and time value. If you're going to create reports from that data, it's usually easier if you have the date and times in separate columns. See how you can do that with a simple formula, or a quick bit of typing.

Continue reading How to Split Date and Time in Excel

Excel Roundup 20160215

Excel Roundup http://blog.contextures.com/

In this week's roundup, Excel skills, make hyperlinks, dashboards, and more.

Continue reading Excel Roundup 20160215

Excel Valentine Cards 2016

Excel Valentine Cards http://blog.contextures.com/

If you dread going into a crowded greeting card store this weekend, to shop for a Valentine's Day Card – you're in luck! You can make a card in Excel instead, and I'll show you two options.

Time spent in Excel is much more pleasant than time spent shopping, right?

Continue reading Excel Valentine Cards 2016