by Oz du Soleil | Nov 9, 2012 | How Tos and Q&As
QUESTION Here’s an example an example of Data Parsing in Excel. Phil sent in this challenge. He receives a report and it’s not useful the way it is. Often, these reports are generated for an executive to read. That same report gets turned over to an...
by Oz du Soleil | Oct 15, 2012 | How Tos and Q&As
QUESTION Erika saw an Excel formula that started with: =+ What’s the deal? ANSWER Nothing. People who grew up with Lotus notes got into the habit of starting a formula with ‘+’ and they carried it over to Excel. What excel does with that is simply...
by Oz du Soleil | Sep 19, 2012 | How Tos and Q&As
THREE people in the past 24 hours have had DROPDOWN DRAMA! But there are easy solutions. We just need to relax. QUESTION Cheryl maintains clean data, by using dropdown lists to control data entry. But there’s a problem she describes: “Oh! I hate it when I...
by Oz du Soleil | Sep 13, 2012 | How Tos and Q&As
QUESTION Cory has a puzzle: Why do I enter 300 and Excel turns it into 3? In order to get 300 I have to enter 30000 ANSWER This must feel like some kind of alien prank. Enter 300 and get 3 or Enter 2716 and get 27.16 WHAT’S THE FRIKKEN DEAL?? Excel has a Fixed...
by Oz du Soleil | Sep 13, 2012 | How Tos and Q&As
QUESTION Joy wants to type 2 – 8 into Excel and 8-FEB is what she keeps getting. No. Joy doesn’t want a date, she’s already married. The goal is to offer a range of options, one of them being 2 – 8 2 – 8 Hours 2 – 8 Vehicles 2...
by Oz du Soleil | Sep 13, 2012 | How Tos and Q&As
Joseph, thanks for the twitter question! QUESTION Joseph wanted to put NOW() in cell A1 and have another cell show Today is 9/12/12 Instead, Excel was showing: Today is 41164.950103588 Basically: How do I get text and date in same cell? And formatted properly? The...