Ever needed to convert the text Sep or September into a 9? Well Excel can convert text months into their respective numbers.
Monthly Archives: August 2013
Extract the Sheet Name in Excel
The long and the sort versions
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.
Get the Right Day In Excel
Formulas and formats
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
Say goodbye to Sum of
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.
Importing Date Data Into Excel
Dates and CSV files
Sometimes when you import data via a CSV (Comma Separated Values) file or a TXT file, the dates don’t always import very well.