Find the answer to your Linux question:
Results 1 to 2 of 2
i use the spreadsheet on windows for a long time but when i decided to build a new computer i put linux on it and copied my spreadsheat files to ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jan 2008
    Posts
    3

    open office spreadsheet problem


    i use the spreadsheet on windows for a long time but when i decided to build a new computer i put linux on it and copied my spreadsheat files to open office but when i go to add new times it always converts it
    example i put in 2:00 and it automaticlly changes to 02:00:00am

    is there a way to stop it from doing that

  2. #2
    Linux Engineer hazel's Avatar
    Join Date
    May 2004
    Location
    Harrow, UK
    Posts
    1,197
    Click on format->cells->time and choose a format that you like.
    "I'm just a little old lady; don't try to dazzle me with jargon!"

Posting Permissions

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