Fix Numbers + more Excel tips

Excel Weekly News from Contextures November 11, 2014

In this week's Excel news, you'll see tips for fixing numbers that don't add up, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

 -  Debra -  ddalgleish@contextures.com

Fix Numbers That Don't Add

If you copy data from a website, and paste it into Excel, the numbers might not add or sort correctly. The data might have hidden characters, such as non-breaking spaces. Here are a few quick ways to fix those numbers.

Click here to see the details: Fix Numbers That Don't Add

Scary Pivot Table Training Giveaway

Thank you to everyone who entered the giveaway for a chance to win an Xtreme Pivot Table Course ($199 value), thanks to John Michaloudis, from My Excel Online Training. The deadline was Sunday, Nov. 9th, and John is selecting 3 random winners for the training.

The winners will be announced on my Pivot Table Blog tomorrow, and will have 24 hours to respond, and claim their prize.

Click here tomorrow, to go to the blog, and see who won the contest: Pivot Table Blog

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

Video: Pivot Table on Protected Sheet

Protect a worksheet and allow users to change some cells, and allow changes to the pivot table. There are some restrictions on the pivot table functions though, when the sheet is protected.

Fall Fruit

All the leaves have fallen off this little tree in our local park, but it is filled with bright red fruit. It might be a crabapple, but if you know for sure, please let me know.

Contextures Products

Save time with our "Done For You" Excel products.

 

________________________

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

 

__

 

Privacy Policy

 

Contextures Inc., Copyright 2018
All rights reserved.