User Panel
User Panel
User Panel
|
Posted: 10/19/2004 1:09:58 AM EDT
[#1]
Databases are much more nifty than spreadsheets, especially if you need to link data.
I cannot help (off top of head, directly) with Excel, but I do know you can restructure a column as 'date' if they ALL match a format you can reformat. Otherwise, switch to a small Database system, like *cough*Access*cough* if you love Micro$oft, otherwise Paradox. 
|
|
|
|
Posted: 10/19/2004 2:11:34 AM EDT
[#2]
1. Click and drag over cells you wish to format.
2. Right Click. Select "number" tab. 3. Select "time" 4. Select desired format [SNL annoying IT guy]You're welcome!! [/SNL annoying IT guy] |
|
|
|
Posted: 10/19/2004 3:08:29 AM EDT
[#3]
Tried that. It just changes the numbers to "0:00". |
|
|
|
|
Posted: 10/19/2004 3:14:42 AM EDT
[#4]
Instead of time, go to custom. in custom, you type what you want. hh:mm will give you 08:00 |
||
|
|
Win a FREE Membership!
Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!
You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.
AR15.COM is the world's largest firearm community and is a gathering place for firearm enthusiasts of all types.
From hunters and military members, to competition shooters and general firearm enthusiasts, we welcome anyone who values and respects the way of the firearm.
Subscribe to our monthly Newsletter to receive firearm news, product discounts from your favorite Industry Partners, and more.
Copyright © 1996-2024 AR15.COM LLC. All Rights Reserved.
Any use of this content without express written consent is prohibited.
AR15.Com reserves the right to overwrite or replace any affiliate, commercial, or monetizable links, posted by users, with our own.
.jpg)
