View Single Post
Old 03-14-2006, 02:15 PM   #1
Kevy Baby
Chowder Head
 
Kevy Baby's Avatar
 
Join Date: Jan 2005
Location: Yes
Posts: 18,500
Kevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of cool
Tech Support question: Excel on Windows

I use a PC at work quite frequently and Excel fairly extensively. Two things I have not been able to figure out:

On Excel on my Mac, I can hit Command-= and it will insert the current date. At one point I knew the keystroke for inserting the current TIME. However, I cannot figure out what the keystroke is for these two items (most importantly, inserting the time) on the PC version. Nor could I figure out how to configure these under the "Customize" option in the Tools menu. BTW: it is Excel 2003. Anybody know these keyboard commands or how to assign them?

Secondly, does anybody now how to provide a count of a series of cells if the information to be counted is text? Basically I would need to just know how many cells in a range have SOMETHING in them. I know that if I use the COUNT function, it returns how many cells have numbers in them. I want to be able to count cells with ANYTHING in them.

Thank you in advance for any assistance!!!
__________________
The thing about quotes on the internet is that you cannot verify their validity.
- Abraham Lincoln
Kevy Baby is offline   Submit to Quotes Reply With Quote