Excel – Convert Text Month to the Month Number
Ever needed to convert the text Sep or September into a 9? Well Excel can convert text months into their respective numbers.
(more…)Extract the Sheet Name in Excel
Being able to extract the current sheet name is often handy. Sheet names have to be unique, so you can name your sheets after departments or divisions. Excel will stop you duplicating a sheet name.
(more…)Get the Right Day In Excel
To get the day of the week in a cell you have two choices. You can use a format or a formula.
Fixing Excel’s Pivot Table headings
Pivot Tables are incredibly powerful and easy to use. Unfortunately their headings can include the terms “Sum of” or “Count of”. This is not always what you’d like to present to users. A macro to the rescue.
(more…)Importing Date Data Into Excel
Sometimes when you import data via a CSV (Comma Separated Values) file or a TXT file, the dates don’t always import very well. (more…)