The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Open Office spreadsheet help

    Discussion in 'Windows OS and Software' started by dave clark, Dec 6, 2005.

  1. dave clark

    dave clark Notebook Enthusiast

    Reputations:
    0
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    5
    I've downloaded Open Office and trying to work on an excel spreadsheet. When I type in numbers with full stops (e.g. 1.2.45) it converts it to date format (01/02/45). Any ideas what I can do to correct this?
     
    dave clark, Dec 6, 2005
    #1
  2. Brian

    Brian Working at 486 Speed NBR Reviewer

    Reputations:
    947
    Messages:
    8,970
    Likes Received:
    1
    Trophy Points:
    205
    You need to format the cells to be general instead of the default setting of date, when numbers are entered in that format.
     
    Brian, Dec 6, 2005
    #2
  3. dave clark

    dave clark Notebook Enthusiast

    Reputations:
    0
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    5
    thanks brian.

    i went to FORMAT then CELLS then NUMBERS and it seems to be set to taht already. e.g category has "numbers" highlighted and format has "general" highlighted.
     
    dave clark, Dec 6, 2005
    #3
  4. Brian

    Brian Working at 486 Speed NBR Reviewer

    Reputations:
    947
    Messages:
    8,970
    Likes Received:
    1
    Trophy Points:
    205
    You might need to edit the auto date settings then. I don't use that program, just trying to guess at the source of the issue.
     
    Brian, Dec 6, 2005
    #4