Excel – Why is my figure displayed as a date?

PROBLEM: when typing a figure into a cell in Excel the figure is displayed as a date?

SOLUTION: quickly change the format of the cell back to a format that displays numbers, not dates.

Excel – Remove formatting from a cell

As soon as you type a date into a cell Excel automatically changes the cell format to be a ‘Date’ format.  This can through up a bit of a challenge if you later delete the date and replace it with a number.

The problem is that the cell’s formatting remains even when you delete the content.  Therefore every time you type a number into the cell it will automatically be formatted as a date.

To change the cell format so that your number is displayed, and not a date:

  1. Select the cell (or range of cells) that are giving you grief.
  2. On the Home tab from the Number group click the drop down arrow on the Number Format command.  Select the Number format.
  3. Your cell will now have the Number format applied and your number will be displayed.

If you found this post helpful please ‘Like’ us!

Facebook
Facebook
Twitter
Google+
Google+
http://excelatwork.co.nz/2014/03/26/why-is-my-figure-displayed-as-a-date