Format Cells to Display a Zip Code Format

  • By Doug H
  • 10 January, 2018
  • Comments Off on Format Cells to Display a Zip Code Format

If you use Excel as a pseudo address book or just have a table is storing addresses a common field is zip code or some kind of postal code.  Often there is some kind of format associated with it like a five digit format or it needs to be separated … Continue Reading →


Show a Date As The Day Of The Week

  • By Doug H
  • 27 December, 2017
  • Comments Off on Show a Date As The Day Of The Week

Sometimes you want more than a date (and no I don’t mean THAT kind of a date).  You want the date to be more express in the day of the week.  Like is it TACO Tuesday or TGIF (Thank God it’s Friday).  Well there are a couple ways to express … Continue Reading →


Copy Formatting from Cells or Charts to Another

  • By Doug H
  • 13 December, 2017
  • Comments Off on Copy Formatting from Cells or Charts to Another

You’ve created your table or chart with the font size/color you want.  You even selected the specific style with it’s fancy curves.  There’s even a specific border color and weight that you’ve set.  Yes… you are a bit obsessed with the look of the data. And you spent a LOT … Continue Reading →


Format Cells to Display a Phone Number Format

  • By Doug H
  • 29 November, 2017
  • Comments Off on Format Cells to Display a Phone Number Format

Are you entering phone numbers into an excel file and need to always put the proper formatting in? Like having the area code in parenthesis? Or maybe you need to have the country code, area code and phone separated with the appropriate dashes? This is not difficult to do if … Continue Reading →


Create a Calculated Item in a PivotTable

  • By Doug H
  • 15 November, 2017
  • Comments Off on Create a Calculated Item in a PivotTable

Creating a Calculated Item in a PivotTable is one of those things you’d might not think of doing, but it has some uses.  For example, say you have some data with geographic categories like: Asia, Europe, North America and South America.  You create your PivotTable and it should summarized sales … Continue Reading →