Results 1 to 5 of 5

Thread: Change default cell format for new tab

  1. #1
    Neophyte piyush.636's Avatar
    Join Date
    Dec 2018
    Posts
    2
    Articles
    0
    Excel Version
    16

    Post Change default cell format for new tab



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    for one of my excel files, every new tab opens with default cell format as "Date". This is the problem with only one excel file, for other files the new tabs open with "General" format for cells. Not sure what has gone wrong with this particular file.

    Any suggestions on how to fix this and reset the cell format to "General" for this file too.

    Thanks in advance for help.

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,689
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Thank you Ken for this secure forum.

  3. #3
    Neophyte piyush.636's Avatar
    Join Date
    Dec 2018
    Posts
    2
    Articles
    0
    Excel Version
    16
    Thanks for the response @Pecoflyer. I read the thread , but it states the obvious as to how to change the format once the new sheet is created. I would be interested to know how can I avoid that and make sure that every new sheet opens with "General" cell formatting by default. Any new pointers on this?

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,689
    Articles
    0
    Excel Version
    2010 on Xubuntu
    I can only do that much, that is, searching the Net.
    Perhaps some other member can answer
    Thank you Ken for this secure forum.

  5. #5
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    887
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by piyush.636 View Post
    Any suggestions on how to fix this and reset the cell format to "General" for this file too.
    Can you attach the relevant Workbook here to download (previously deleted data)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •