Default number format in Excel


Joined
Aug 9, 2018
Messages
1
Reaction score
0
I have one excel workbook and always changes number become a date, I think its about default cell number contents. How to changes it become normal as when I enter 0 a cell content is 0 not 0/0/0 as does now.
Thanks for kind.
 

Becky

Webmistress
Administrator
Joined
Mar 25, 2003
Messages
7,346
Reaction score
1,473
Welcome to the forum :)

Excel shouldn't change numbers to dates by default, are you working with an old / existing spreadsheet? Click on one of the cells to see the format (displayed in the ribbon under the 'Number' section):

excel number format.jpg


If it is set to Date then change it to General or Number. You can do this to multiple cells at the same time by selecting them and then making the changes. You can also right click on the selected cell(s) and then selecting 'Format cells...' for more options.

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top