Excel Hack 60: 12 ways to use the TEXT() function to change your data to the format you like (image post)
The =TEXT() function is used to convert a value to text in a format you specify. So if you ever run into issues with Excel expressing data formats other than what you prefer, the =TEXT() function is here to the rescue! Below is an image showing 12 ways you can use the TEXT function to