08-26-2005, 05:19 PM
|
#1 |
|
Chief of Naval Operations
  
Join Date: Mar 2000
Location: Kansas City area
Posts: 10,947
  |
OpenOffice help!
I'm trying to type up a tv schedule of my shows for this season using the Spreadsheet in OpenOffice.
Everytime I type a time, such as 7:00, it goes to ###. In the edit box thingy it then shows 07:00:00am BAH! I've tried for ages to figure out how to change it so it just ****ing stays what I type and doesn't format or whatever it is doing. Anyone know? I've tried reading the help stuff but... TIA!
__________________
Check out my spoilers for over 20 shows @ SpoilerFix.com Check out my TV blog, where I post weekly & daily TV schedules, TV news, interviews with TV stars & more! All new TV forums as well @ TV Is My Pacifier |
|
|
|
08-26-2005, 06:51 PM
|
#2 |
|
Commander
 
Join Date: Jun 2004
Location: Montgomery
Posts: 1,264
|
the cell may be too small to show the value
try resizing it manually by draging the COLUMN (A B C D E F) to resize OR double click the coloumn (between 2 columns ex. between C & D) (this will autosize to fit the contents)
__________________
Dyin' ain't much of a living, boy 
|
|
|
|
|
08-26-2005, 06:53 PM
|
#3 |
|
Rear Admiral Upper Half
 
Join Date: Nov 2000
Location: FL
Posts: 3,240
 |
If the time is always going to be in the same column(s), just format it up front. I've never found it to be a problem.
|
|
|
|
|
08-26-2005, 06:53 PM
|
#4 | ||
|
Chief of Naval Operations
Join Date: Mar 2000
Location: Kansas City area
Posts: 10,947
|
Quote:
Yes, but how? I can't figure that out. heh Quote:
Nah, I know how to resize the columns.  I don't WANT it to show the 07:00:00amI want it to show what I type. 7:00 only.  heh |
||
|
|
|
|
08-26-2005, 07:51 PM
|
#5 |
|
Rear Admiral Upper Half
Join Date: Nov 2000
Location: FL
Posts: 3,240
|
Not sure if this is what you're getting at but...
Highlight the column you're looking to work with. From the "Format Cells" tab, choose "Time" then the first option from the "Format" area. |
|
|
|
|
08-26-2005, 08:12 PM
|
#6 |
|
Chief of Naval Operations
Join Date: Mar 2000
Location: Kansas City area
Posts: 10,947
|
oooh! Exactly what I need!
Thanks faither!  |
|
|
|
|
08-27-2005, 08:32 AM
|
#7 |
|
Commander
Join Date: Jun 2004
Location: Montgomery
Posts: 1,264
|
Oh, thats what you were asking, lol. I knew that.
|
|
|
|
|
08-27-2005, 09:37 AM
|
#8 |
|
Rear Admiral Upper Half
Join Date: Nov 2000
Location: FL
Posts: 3,240
|
You're welcome, Jenny!
 |
|
|
|
Linear Mode
