by Oz du Soleil | Sep 20, 2012 | Case Studies
This stood as the only time in 12 years that I almost accepted defeat. With 70% of the work done, the last 30% was excruciating. Summary The client was conducting a Data Transfer from one database to another. They successfully downloaded the data from the old database...
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...
