Your Ad Here Your Ad Here
Results 1 to 6 of 6

Thread: Excel 2007 problem

  1. #1
    lightshow's Avatar Asleep at the wheel
    Join Date
    Mar 2003
    Age
    32
    Posts
    924
    I am having problems with excel 2007's auto correct features.

    For example, open up excel

    pick any cell

    type "October 2006"
    it will autocorrect it to 10/1/2006

    That is not what I want, I don't want it to make it look like day 1 of october.

    or type "November 06"
    it will autocorrect to Nov-07

    I've looked at the excel options under the proofreading tab (found that through help)

    But it only gives me the autocorrect dictionary that doesn't talk about re-formatting dates.

    Any suggestions?
    I miss the days of random nut '03
    Click for more activation options, then activate by telephone. Run the keygen.
    if I call them, aren't they going to get me? (you know, down there)

  2. Software & Hardware   -   #2
    Right click on a cell or a collection of cells and choose "format cells"

    From there you can either make up a custom formatting for those selected cells, or choose a predefined one. (what you're looking for may be under "Date" in the list to the left)

    Hope this helps.

  3. Software & Hardware   -   #3
    lightshow's Avatar Asleep at the wheel
    Join Date
    Mar 2003
    Age
    32
    Posts
    924
    I know that I can do it manually, but is there a setting that will make it not automatically autocorrect without having to individually changing the cell's format settings every time I use excel?
    I miss the days of random nut '03
    Click for more activation options, then activate by telephone. Run the keygen.
    if I call them, aren't they going to get me? (you know, down there)

  4. Software & Hardware   -   #4
    Chewie's Avatar Chew E. Bakke
    Join Date
    Feb 2004
    Posts
    4,883
    Heh, I just tried it and it does automatically change the data you enter.
    Doesn't seem to be a switch to turn it off either.
    What a fucking stupid thing to have to put up with!
    There isn't a bargepole long enough for me to work on [a Sony Viao] - clocker 2008

  5. Software & Hardware   -   #5
    Barbarossa's Avatar mostly harmless
    Join Date
    Jun 2002
    Location
    Over here!
    Posts
    19,631
    Same happens in excel 2003

  6. Software & Hardware   -   #6
    lightshow's Avatar Asleep at the wheel
    Join Date
    Mar 2003
    Age
    32
    Posts
    924
    Man, that sucks that it has to do that. I can't believe they don't have an option to disable it...
    I miss the days of random nut '03
    Click for more activation options, then activate by telephone. Run the keygen.
    if I call them, aren't they going to get me? (you know, down there)

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
  •