+ Reply to Thread
Results 1 to 6 of 6

Default cell format is "Date" - I want to change it to "General" - how do I do it globally

  1. #1
    Registered User
    Join Date
    07-10-2015
    Location
    Sydney, Australia
    MS-Off Ver
    v10
    Posts
    8

    Unhappy Default cell format is "Date" - I want to change it to "General" - how do I do it globally

    Hi Forum

    Hoping someone can help out

    I have an excel workbook that has many sheets in it - and is a tool I use

    Somehow - at some point - every non specified cell in the workbook - defaults to the formatting style of "Date" - this is really frustrating whenever I want to enter a new formula in a new cell - I have to change all the new cells to "General" or "Number" format - is there some way to change all non specified or 'empty' cells to "General"?

    Would really appreciate any advice

    Thanks
    Lily

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Default cell format is "Date" - I want to change it to "General" - how do I do it glob

    You have some options:

    1. Blanket Format everything General (this will mess up your dates)
    2. Run Code to check every cell is empty, and if so make it General (this will take forever since there 17 billion cells per worksheet)
    3. Run Code on significantly less cells, say maybe a . This will take a few seconds or less and make life more bearable.

    To use the code below, go to Excel, hit Alt+F11, Insert->Module, and paste the code below. Once you make any revisions as needed, hit F5 to run the code.

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    07-10-2015
    Location
    Sydney, Australia
    MS-Off Ver
    v10
    Posts
    8

    Re: Default cell format is "Date" - I want to change it to "General" - how do I do it glob

    Thank you Daffodil1 - much appreciated! worked like a bought one!!!

  4. #4
    Registered User
    Join Date
    07-10-2015
    Location
    Sydney, Australia
    MS-Off Ver
    v10
    Posts
    8

    Re: Default cell format is "Date" - I want to change it to "General" - how do I do it glob

    By the way - this is my very first post on this site - and you were very helpful - I think I have successfully given you 'reputation' but I cannot see HOW to mark it as "SOLVED" can someone help me out?

  5. #5
    Registered User
    Join Date
    07-10-2015
    Location
    Sydney, Australia
    MS-Off Ver
    v10
    Posts
    8

    Re: Default cell format is "Date" - I want to change it to "General" - how do I do it glob

    SOLVED! I just discovered it!!!!
    thanks

  6. #6
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Default cell format is "Date" - I want to change it to "General" - how do I do it glob

    Awesome! Glad I could help out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Convert from "general" (YYYYMMDD) to specific "custom" format (YYYY.MM.DD)
    By Ella_p in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2013, 02:23 AM
  2. Replies: 2
    Last Post: 11-01-2012, 04:35 PM
  3. [SOLVED] Set default data format to "text" instead of "general"
    By Delta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2012, 02:44 PM
  4. Replies: 1
    Last Post: 10-31-2010, 02:56 AM
  5. [SOLVED] How to change date as general "200306" to date "06/2003"
    By Delwyn in forum Excel General
    Replies: 1
    Last Post: 06-14-2005, 11:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1