OpenOffice question - GoFuckYourself.com

Sly · 10-09-2009, 07:17 PM

I am using the spreadsheet program and typing in a time value "00:18:05", hours , minutes, and seconds. The program insists on formatting this so that it reflects an hour of the day instead. How do I make it stop automatically formatting my cells?

After Shock Media · 10-09-2009, 07:20 PM

Pretty sure you just select the cells, select format cell, change time formats.

Sly · 10-09-2009, 07:22 PM

Yeh. That was it.

I hate moments like this. LOL.

After Shock Media · 10-09-2009, 07:23 PM

happens to all of us.

VIPimp · 10-09-2009, 08:22 PM

Quote:

Originally Posted by Sly

I hate moments like this. LOL.

You have a lot of those moment ?

10-09-2009, 07:17 PM	#1
Sly Let's do some business! Industry Role: Join Date: Sep 2004 Location: Austin, TX Posts: 31,292	OpenOffice question I am using the spreadsheet program and typing in a time value "00:18:05", hours , minutes, and seconds. The program insists on formatting this so that it reflects an hour of the day instead. How do I make it stop automatically formatting my cells? __________________ Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted Windows VPS now available. Wanted: CCBill pay sites for sale

10-09-2009, 07:20 PM	#2
After Shock Media It's coming look busy Join Date: Mar 2001 Location: "Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn". Posts: 35,299	Pretty sure you just select the cells, select format cell, change time formats. __________________ [email protected] ICQ:135982156 AIM: Aftershockmed1a MSN: [email protected]

10-09-2009, 07:22 PM	#3
Sly Let's do some business! Industry Role: Join Date: Sep 2004 Location: Austin, TX Posts: 31,292	Yeh. That was it. I hate moments like this. LOL. __________________ Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted Windows VPS now available. Wanted: CCBill pay sites for sale

10-09-2009, 07:23 PM	#4
After Shock Media It's coming look busy Join Date: Mar 2001 Location: "Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn". Posts: 35,299	happens to all of us. __________________ [email protected] ICQ:135982156 AIM: Aftershockmed1a MSN: [email protected]