MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

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.