Horizontal Line in Excel Header and Footer


2017/12/06
By
Horizontal-Line-in-Excel

  We would like to add a horizontal line to the header of an Excel file to be repeated on every page. To add a horizontal-line we first need to create an image of a horizontal line in your favorite imaging software. Create a PNG image 660 by 3 pixels and color it in some shade of gray.  Save the image with an appropriate meaningful name.  You will be using this file each time you need to add a line to Excel header of footer. Now, insert this image into Excel header: Note that &[Picture] code should be bellow any other code that you have in the header. Now we have…

Read more »


Can’t convert Number into a string in Excel (not all space characters are the same)

2017/12/05
By
All spaces appear the same

Problem started as a simple CAN’T CONVERT NUMBER INTO A STRING in Excel. But solving this problem revealed a deep difference between character Space and character No-Break Space. I was  coping some text from Internet and pasting it into Excel to extract QTY, Amount and Total.  The ultimate goal is to calculate the commissions, but that is not important here.  Below is an example of text that I would normally copy into Excel: JO - 10:14:53 Sold 200s @ $19.19 - Total: $3,837.90 JO - 10:10:53 Sold 300s @ $19.19 - Total: $5,749.90   Problem: I can extract quantity 200 into a separate cell, but I can’t do any arithmetic operation on a resulting number.  All the usual tricks as for example multiplying by 1, or…

Read more »

Aug 29 WED – Capri – Day 1 [… in progress …]

2017/12/04
By

 […in progress…] We are planning to visit Capri, Pompei and Amalfi coast over the next 3 days and 3 nights.  Overnight stay at Capri is not even planned.  Buy we are very limb and flexible. Today is Wednesday. We woke up in a spacious villa in Sorrento. Internet still doesn’t work?  Today we might take a trip to Capri.  Today we should find a place to park our car (€20 per day), find a hotel here in Sorrento for nights of Thursday and Friday, and yes – collect out things for a overnight trip to Capri. After breakfast I confirmed that they will have a room for us right here at…

Read more »

First Night Alone – Shoal Pond Trail – Impossible to Put in Words

2017/12/03
By
Shoal-Pond-Trail-Alone

    Completely alone in the woods.  For many miles around.  I didn’t see a single person on the entire wilderness portion of the trail.  And now, as planned, it is my first night in the White Mountains is closing in around me. Even now it seems strange to remember all the nervous mental preparation inside.  It started around 3PM that day.  I suddenly realized that for the next 12-15 hours I will not meet another person, and I would have to rely completely and entirely on my own. The sun was on and off behind disturbing dark clouds. The bugs were intense and preferred to ignore the spray.  And of…

Read more »

2017/12/02
By
placeholder-medium

Caution! This site is for reference only. This site will be discontinued soon. Please proceed directly to new PROD site:   https://domainwebcenter.com/   Thank you, Administration [2017-12-02 14:55 EST]

Read more »

How to Export Yahoo! Group mebers into Excel – Painfull!

2017/12/02
By
How to Export Yahoo! Group mebers into Excel – Painfull!

This is a poor’s man manual on how to export Yahoo! group members list into Excel. Yahoo! used to have this simple feature right on their page, but it is gone now. Instead you would have to do this painful semi-archaic way of getting the data.   To make it look easy we divived the whole procedure into 3 simple steps: Step1.  Display all your Yahoo! group members in “Display Name” order Step2. Copy into Word and fix data inconsistencies Step 3. Copy into Excel and create a link sheet with a proper list         Step1.  Display all your Yahoo! group members in “Display Name” order That is easy.  You need to…

Read more »

How to Compare SQL SmallDateTime Fields for Equality

2017/12/01
By
MS SQL Server 2008 R2

It is meaningless to compare for equality (==) two fields of type SmallDateTime, because they contain time component and they are hardly ever the same. Here are some interesting ways around this problem to check, if two SmallDateTime fields have the same date component.

Read more »

Aug 28 TUE – From focused Napoli to havenly Sorrento

2017/11/30
By
2012-08-28 17-36 Sorrento Italia

In the morning of 28-th we were anxious to get out.  On the one hand, our car was blocked on the hotel protected parking lot by two other cars, and on the other, we did not want to fight unfair Wi-Fi charges at the front desk with two load and obnoxious ladies. But both our anxieties got resolved on their own accord.  Car got unblocked by a clever maneuvering, and a lonely front desk lady decided not to pick fight for unjust €5 with two of us armed with a copy of paper stating that Wi-Hi supposed to be free.  She was just throwing a fiery glances like a cobra in a pit.  But she…

Read more »

Body, Mind and Decision Making

2017/11/29
By
Processing-Requests

  Going Nowhere, Aiming for Nothing Instead of going to the forest, to my favorite bog, I stayed home to write.  That is in accordance with principle “Going nowhere, aiming for nothing”.  Instead of fighting traffic, biking through the bumpy path and covering myself with a bug spray from head to toe, I just took a pen in my hand and begun drawing these characters on paper. ~ Improving Our Bodies and Improving Our Minds Who does that?  Something is working on your body and your mind to make them faster, leaner, smarter.  What is that something? Body is like a Switzerland.  Mind is like a capital of Switzerland – Bern.  And…

Read more »

IE10 is not saving passwords and user names

2017/11/28
By
IE10 is not saving passwords and user names

I hope this post will help a lot of frustrated users out there. PROBLEM: IE10 was working fine, but at one point it stopped saving user names and passwords for web sites. This most securely-configured browser, so switching was not an option.   Here is my solution.  Please see, if it works for you. SOLUTION: For extra security I’ve checked Delete browsing history on exit (see image 1).  I did it without understanding, what it is I am requesting to delete.  To solve my problem, I had to uncheck Cookies and website data on the very next Delete screen (see image 2).  Now IE10 is preserving user names in passwords for visited…

Read more »

Using Ajax Toolkit Controls on Pages With Other Scripts and Master Pages

2017/11/27
By
Ajax Extended Calendar

[ASP.NET – This  material was tested on Win7, W2K8 Server,  IS7 and IIS 7.5  and Microsoft Visual Web Developer 2010]   Install Proper Version Download and unzip proper version form http://ajaxcontroltoolkit.codeplex.com/releases/view/76976 Open the site where you intend to uses Ajax Controls, Follow  generic instruction and add a new control tab inside your Visual Studio or Web Dev. By doing this, you copy a file “AjaxControlToolkit.dll” and others into your site Bin directory. Text file  “/Bin/AjaxControlToolkit.dll.refresh” has a pointer to a folder where you unzipped your Ajax Toolkit. If you move Toolkit installation files somewhere, you can always update the pointer manually.   Use Ajax Control Open the page that you intend to…

Read more »