Different types of cell formats will display your data differently in Excel 2013. Changing the format of a cell to best suit the data contained within it is a simple way to ensure that your data displays correctly. For example, a date that is formatted as a “Date” cell might display as “6/27/2016.” However, if that same cell is formatted as a number, then it might display as “42548.00” instead. This is just one example of why it is important to use proper formatting when possible.
If data is not displaying properly in a cell, then you should check the cell formatting before you start troubleshooting. Our guide below will show you a quick location to check so you can see the formatting that is currently applied to a cell.
What Format is a Cell in My Spreadsheet?
This guide will show you how to select a cell, and then see the format of that cell. This is helpful information to have if you are having certain types of issues that are difficult to fix. For example, you might need to check a cell’s format if the cell contains a formula that is not updating. So continue reading below to see how to view the format currently applied to a cell.
Step 1: Open the spreadsheet in Excel 2013.
Step 2: Click the cell for which you wish to view the current format.
Step 3: Click the Home tab at the top of the window.
Step 4: Locate the drop-down menu at the top of the Number section in the ribbon. The value shown in the drop-down is the current format for your cell. The format of the cell that is currently selected is “Number.” If you click that drop-down menu, you can select a different format for the currently-selected cell.
Do you want to remove all of the formatting from a cell and start from scratch? This article – https://www.solveyourtech.com/removing-cell-formatting-excel-2013/ – will show you a short method that clears all of the formatting from a cell.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.