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. 02-01-2008 #1
    anchortim
    anchortim is offline
    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
    Reply With Quote Reply With Quote
  2. 02-03-2008 #2
    hazel
    hazel is offline
    Linux Engineer hazel's Avatar
    Join Date
    May 2004
    Location
    Harrow, UK
    Posts
    1,079
    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!"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules