Home // Blog & Excel Tips // Excel default cell format as date

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 
2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Excel default cell format as date

Comments Closed
Uncategorised

Excel default cell format as date

For some reason, it seems that the Excel default cell format as date on some spreadsheet. This can be really annoying as often all your numbers (or what you expect to be numbers) are shown as dates. Also, as far as we can tell there is no obvious reason for this happening and it seems to occur on spreadsheets that previously were correctly formatted.

This appears to be a problem with the default setting of a cell style. In order to correct this you need to do the following (see graphic below).

  • Click on the Home Tab
  • Click on Cell Styles
  • Right Click on the Normal box
  • Click on Modify
  • A new dialogue box will appear. Click on the Format button and then choose ‘General’ (or the format you want).

Excel-default-cell-format-as-date