Default number format in Excel

Discussion in 'Microsoft Office' started by Agoes Rodiman, Aug 9, 2018.

  1. Agoes Rodiman

    Agoes Rodiman

    Joined:
    Aug 9, 2018
    Likes Received:
    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.
     
    Agoes Rodiman, Aug 9, 2018
    #1
    1. Advertisements

  2. Agoes Rodiman

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,399
    Location:
    Manchester
    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!
     
    Becky, Aug 9, 2018
    #2
    Abraham Andres Luna likes this.
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.
Similar Threads
There are no similar threads yet.
Loading...