Excel Tips

Convert Feet and Inches to Decimal Feet »

February 7, 1999

In Excel, learn how to take a single column of feet, inches, and fractional inches and use the custom function Feet () to convert to decimal feet and back. This Excel user-defined function will make it easy to convert between measurements that are easily human-readable and convert them to measurements which are good for calculating. MrExcel will teach you how to use a customer function to do the conversion in Excel.

Excel 97 introduced new User Forms. In English, teach me how to create and use a list box. »

January 17, 1999

Like many of you, I started writing Excel macros in Excel 5.0. This whole Macro Editor in Excel 97 is a bit intimidating. For this week's tip, I will show you, step by step, how to create the list box for this project. The focus this week is just on the combo box.

Convert Excel Days To Months »

November 21, 1998

I want to use an Excel pivottable to summarize the data, but I want to see it at the month level instead of at the daily level.