Excel – Why is my figure displayed as a date?

Posted: March 26, 2014

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.

Was this blog helpful? Let us know in the Comments below.

If you enjoyed this post check out the related posts below.

Join our free insiders Group!

Learn how to SAVE TIME and WORK SMARTER, without the 'techie' speak!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join our free insiders club! 

Receive 100+ Steps to Becoming Proficient in Excel