Excel.Tips.Net: Converting Numbers Into Words
There are times when it is beneficial, or even mandatory, to spell numbers out.
Excel.Tips.Net: Converting Numbers Into Words Read More »
Excel.Tips.Net: Calculating the Distance between Points
Mike keeps track of a series of latitude and longitude values in an Excel worksheet. As these are essentially points on a grid, Mike would like to calculate the distance between any two given latitude/longitude pairs.
Excel.Tips.Net: Calculating the Distance between Points Read More »
Excel.Tips.Net: Adding Leading Zeroes to ZIP Codes
When you import ZIP Codes from a text file into an Excel workbook, it is not uncommon for Excel to translate the values as numbers rather than as ZIP Codes.
Excel.Tips.Net: Adding Leading Zeroes to ZIP Codes Read More »
Excel.Tips.Net: Synchronizing Lists
You may have an occasion when you have two data lists that we want to “line up.”
Excel.Tips.Net: Synchronizing Lists Read More »
Excel.Tips.Net: Converting European Dates to US Dates
Linda asked if there is a formula that will convert a date shown in the European fashion of day/month/year to the US version of month/date/year. Truth be told, this may not be necessary.
Excel.Tips.Net: Converting European Dates to US Dates Read More »
Excel.Tips.Net: Changing the Height of Worksheet Tabs
Cindy noted that when naming worksheet tabs, the width of the tabs varies based primarily on the name of the tab. She wonders if there is a way to increase the height of a worksheet tab.
Excel.Tips.Net: Changing the Height of Worksheet Tabs Read More »
Excel.Tips.Net: Setting a Default File Format
Normally, Excel saves your worksheets in the workbook format that is appropriate for the version of the software you are using.
Excel.Tips.Net: Setting a Default File Format Read More »
Excel.Tips.Net: Returning a Weight and a Date
David asked how he could return a date associated with the maximum value in a particular column. In David’s application, he had two columns containing dates and weights associated with those dates. He could figure out how to determine the maximum weight, but not how to pull the date on which that weight occurred.
Excel.Tips.Net: Returning a Weight and a Date Read More »
Excel.Tips.Net: Can’t Sort Imported Data
Can’t sort data you have imported into Excel? Learn why this is happening and how to fix it.
Excel.Tips.Net: Can’t Sort Imported Data Read More »
Excel.Tips.Net: Displaying Excel’s Developer Tab
One tab that is especially necessary for advanced users is the Developer tab.
Excel.Tips.Net: Displaying Excel’s Developer Tab Read More »