Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Restore cell format to default

  1. #1
    Join Date
    21st June 2007
    Posts
    80

    Restore cell format to default

    Hi,

    I have an annoying problem with an excel workbook which I cannot find the solution to online.

    When I add a new sheet all the cells in the sheet are formatted to Date by default.

    How can I change this back to General?

    The workbook has too much data to rebuild in a new workbook

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st September 2010
    Posts
    7,334

    Re: Restore cell format to default

    You don't mention a version...

    2007: Select the range to clear and use the Eraser Dropdown in the Editing Group of the Home tab - you'll find an option to Clear Formats.
    <2007: Select the range and use Edit, Clear, Formats (From memory - and that's getting unreliable!)

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    2nd May 2008
    Location
    Ubique
    Posts
    1,823

    Re: Restore cell format to default

    Change the Normal style of the workbook so that it uses General as the number format.
    Rory
    Theory is when you know something, but it doesnít work. Practice is when something works, but you donít know why. Programmers combine theory and practice: nothing works and they donít know why

  4. #4
    Join Date
    2nd March 2006
    Location
    London
    Posts
    988

    Re: Restore cell format to default

    If your Normal style is missing, open another workbook that is OK, navigate back to the original, and Merge Styles/From and select the other workbook.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    21st June 2007
    Posts
    80

    Re: Restore cell format to default

    thank you!

    I have to admit that was driving me BANANAS!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Restore Default Settings
    By ScottMc in forum EXCEL HELP
    Replies: 1
    Last Post: March 22nd, 2008, 10:47
  2. Restore Cell Default Format
    By Gab in forum EXCEL HELP
    Replies: 3
    Last Post: June 27th, 2007, 22:00
  3. Deleting cell and setting it to default format
    By TroyArthur in forum EXCEL HELP
    Replies: 4
    Last Post: October 17th, 2005, 08:24
  4. Default format
    By kathy1013 in forum EXCEL HELP
    Replies: 3
    Last Post: May 8th, 2003, 00:54

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
  •  
porno