Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Member Login
Posted: 10/19/2004 1:02:44 AM EDT
Anyone know how to format cells in an Excel spread sheet to change text numbers to a time format? Example would be 800 to 08:00 or 8:00 and 1700 to 17:00. I need to sort two different spread sheets to match certain entries. If I could change one of the spread sheets from text numbers to the time, I could make the matches much quicker.
Link Posted: 10/19/2004 1:09:58 AM EDT
Link Posted: 10/19/2004 2:11:34 AM EDT
[Last Edit: 10/19/2004 2:12:50 AM EDT by Sewer_Urchin]
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]
Link Posted: 10/19/2004 3:08:29 AM EDT

Originally Posted By Sewer_Urchin:
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]



Tried that. It just changes the numbers to "0:00".
Link Posted: 10/19/2004 3:14:42 AM EDT
[Last Edit: 10/19/2004 3:14:50 AM EDT by mjohn3006]

Originally Posted By smokycity:

Originally Posted By Sewer_Urchin:
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]



Tried that. It just changes the numbers to "0:00".



Instead of time, go to custom. in custom, you type what you want. hh:mm will give you 08:00
Top Top