Excel 2013

Discussion in 'Microsoft Surface Help' started by psnative, May 21, 2013.

  1. psnative

    psnative Member

    Joined:
    Apr 9, 2013
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    Where is "undo auto format" in excel/word 2013? I used to use works, but I had to upgrade b/c they no longer support works. I think I just right clicked in works & "undo auto format" came up but I can't find it in office. I see "undo" but that does not work for it.
     
  2. J515OP

    J515OP Super Moderator

    Joined:
    Jun 19, 2012
    Messages:
    2,177
    Likes Received:
    262
    Trophy Points:
    0
    Location:
    Northern CA
    My Device:
    RT
    After an auto action a small box with a lightening bolt show appear at the bottom right of the area where the action took place (i.e. the range of cells). Click that and you should then see a menu that allows you to undo the auto action.

    ZA010179222.gif

    Undo or turn off automatic formatting - Excel - Office.com
     
  3. psnative

    psnative Member

    Joined:
    Apr 9, 2013
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    ok, I get that now but it doesn't show up in this instance. I am in a spread sheet typing this number...0877. When I go to the next cell it takes the "0" off & no lightning box. I'll just use a "O" for now I guess.
     
  4. J515OP

    J515OP Super Moderator

    Joined:
    Jun 19, 2012
    Messages:
    2,177
    Likes Received:
    262
    Trophy Points:
    0
    Location:
    Northern CA
    My Device:
    RT
    Ah, that is not so much auto formatting as cell formatting and the way Excel treats numbers by dropping the lead 0. If you don't need the number to be a number for calculating but rather a string of text (such as an employee number) then you can put ' (an apostrophe) at the beginning of the number and it will be treated like a string of text leaving the leading zeros but not showing the '.
     
  5. psnative

    psnative Member

    Joined:
    Apr 9, 2013
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    That works! TY
     
  6. DOS

    DOS Active Member

    Joined:
    Apr 8, 2013
    Messages:
    145
    Likes Received:
    36
    Trophy Points:
    28
    Location:
    USA
    If you still want to treat the value as a number instead of a string (for data manipulation or totaling). You can use Customer Formatting for the Cell(s) to create a "mask". For example: a mask of '00000' will make all values 5 digits with leading zeros (00123).
     
  7. J515OP

    J515OP Super Moderator

    Joined:
    Jun 19, 2012
    Messages:
    2,177
    Likes Received:
    262
    Trophy Points:
    0
    Location:
    Northern CA
    My Device:
    RT
    I figured that might be where it was heading but started with the easy stuff first ;)
     

Share This Page

Search tags for this page

2013 excel auto format date turn off

,

autoformat in word for surface

,

cannot find undo in excel 2013

,

disable the auto formatting option excel 2013

,

excel 2013 undo ty

,

how do you turn off undo in excel 2013

,

how to disable undo in excel 2013

,

office 2013 turn off auto read feature

,

surface pen in excel 2013

,

where is autoformat in excel 2013