The Poojer Posted June 17, 2009 Posted June 17, 2009 i feel like a frigging idiot here...trying to create a spreadsheet to track my son's swim times. I am formatting some columns as 'general' so i can do <seconds:hundreths of seconds>. 2 of the columns are working fine, the 3rd keeps chaning formats on me.....damn it is frustrating the hell out of me because i know i am missing a really basic step.....HELPPPPPPPPP!!!!!!!
plenzmd1 Posted June 17, 2009 Posted June 17, 2009 i feel like a frigging idiot here...trying to create a spreadsheet to track my son's swim times. I am formatting some columns as 'general' so i can do <seconds:hundreths of seconds>. 2 of the columns are working fine, the 3rd keeps chaning formats on me.....damn it is frustrating the hell out of me because i know i am missing a really basic step.....HELPPPPPPPPP!!!!!!! Pooj, where do you all swim. My kids are on the RCC team in JRAC, and also NOVA in the winter. Your son swimming either NOVA or Poseidon?
damj Posted June 17, 2009 Posted June 17, 2009 i feel like a frigging idiot here...trying to create a spreadsheet to track my son's swim times. I am formatting some columns as 'general' so i can do <seconds:hundreths of seconds>. 2 of the columns are working fine, the 3rd keeps chaning formats on me.....damn it is frustrating the hell out of me because i know i am missing a really basic step.....HELPPPPPPPPP!!!!!!! Pooj ... it's not you ... I know what you're talking about it ... I just recently starting seeing that happen in Excel 2003 ... sucks and is aggravating. I have no idea why ... It always to change formulas to "text" format, so you have to reset the format to general, then hit "F2" and enter to reset. I'm a MicroCrap hater!
damj Posted June 17, 2009 Posted June 17, 2009 Your son swimming Poseidon? That must be quite an adventure, especially the morning after. {groan} Now you'll have that song stuck in your head all day, wish you luck with that {mwah ha ha}
The Poojer Posted June 17, 2009 Author Posted June 17, 2009 no we are RMAL and we are Shenandoah, I may look into year long, he shows some promise, especially in backstroke Pooj, where do you all swim. My kids are on the RCC team in JRAC, and also NOVA in the winter. Your son swimming either NOVA or Poseidon?
Kevbeau Posted June 17, 2009 Posted June 17, 2009 Go under Format Cells:Number:Custom and choose mm:ss That should get you what you need.
/dev/null Posted June 17, 2009 Posted June 17, 2009 Your problem is that you're not using Open Office. It took you 1 hour and 33 minutes to make that remark. You're slipping dude
Fezmid Posted June 17, 2009 Posted June 17, 2009 It took you 1 hour and 33 minutes to make that remark. You're slipping dude That's because I'm getting more and more swamped with work....
/dev/null Posted June 17, 2009 Posted June 17, 2009 That's because I'm getting more and more swamped with work.... I know that feeling
The Poojer Posted June 17, 2009 Author Posted June 17, 2009 trying that....it keeps changing the format to read it as if it is a date....55:81 translates to January 3, 2009 3:58 or something like that.....it is killing me Go under Format Cells:Number:Custom and choose mm:ss That should get you what you need.
\GoBillsInDallas/ Posted June 17, 2009 Posted June 17, 2009 i feel like a frigging idiot here...trying to create a spreadsheet to track my son's swim times internet porn viewing. I am formatting some columns as 'general' so i can do <seconds:hundreths of seconds>. 2 of the columns are working fine, the 3rd keeps chaning formats on me.....damn it is frustrating the hell out of me because i know i am missing a really basic step.....HELPPPPPPPPP!!!!!!! Fixed.
justnzane Posted June 17, 2009 Posted June 17, 2009 Fixed. nice. The real question is who else tracks their porn viewing with excel, besides me ?
/dev/null Posted June 17, 2009 Posted June 17, 2009 nice. The real question is who else tracks their porn viewing with excel, besides me ? Dude you need some way to keep track of it all. I just hacked your computer and saw how much you have # du -sh c:\porn 75M donkey 350G gay 0M girls 50M midgets 10M sarah palin
Recommended Posts