
Dec 13, 2013
Imagine you’re in a situation where you want to send a list of the employees’ birthdays so that everyone in the company will know when to send their regards to others in the organisation. You have a list of all of the birthdays including the birth year in an Excel spreadsheet. How would you convey this information in a way that wouldn't embarrass anyone or betray any confidences by revealing the year people are born? You could edit each birthday and remove the year from the field, but what if you need the information later? Instead, what you can do is create a custom number format, or a mask, in Excel 2010 that will only display the information that you want when you print it out or convert to PDF.- In your Excel spreadsheet, select the column of dates.
- In the ‘Home’ tab, open the dialogue box of the ‘Numbers’ panel. You’ll see many different styles of dates under the ‘Category’ area. Select the ‘Custom’ option.
- In the right box, a number of different formats will appear. Choose ‘d-mmm’ from the list to display only the day and the Alpha month and click OK.
- Repeat steps 1 and 2 above.
- In the ‘Type’ text box, type in the format ‘dddd.’ This will display only the day that the date occurred.
- Repeats steps 1 and 2 above.
- In the ‘Type’ text box, type in ‘“Employee ID-” ####.
How do your Excel skills stack up?
Test NowNext up:
- PowerPivot's CALCULATE function to the rescue
- The impact of discounting and why you should not be offering it
- High Availability in Lync Server 2013
- The truth about Santa Claus
- Happy New Year!
- Work offline with SharePoint Workspace 2010
- Creating Effective Lists and Tables in Excel
- Cast out that colourcast in Photoshop
- Power View just got better!
- How to do an IF statement in Excel
Previously
- The Pros and Cons of SSAS Tabular Models in SQL Server 2012
- Customising Layouts in SharePoint Designer 2010
- Deploying Web and Service Applications to Windows Azure
- A Knotty Issue
- Quoting in PowerShell for newbies
- How to integrate OneNote and Outlook
- Support the Salvation Army Christmas Appeal
- What's new in Windows 8.1 for Developers
- Centre objects in Photoshop CS6 with precision
- The dirty little secret of Transparent Data Encryption (SQL Server 2012)