| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to make a cell hold numbers as a length of time in xcel?
I am setting up a "tab-delimited" file to import into another program. The
file is to import "Titles" for Television. Each "Title" carries a length that is measured in HH:MM:SS. When I input these numbers into the cell, they get converted to a date with a clock time EXAMPLE 40:46:00 turns into "1/2/1904 4:46:00 PM". I just want to put in 46:46:00 and have it stay as "text"......HELP ME PLEASE |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make repeat long numbers shortcut ? | Excel Worksheet Functions | |||
| When calling a different file, can I make the tab equal to a cell? | Excel Discussion (Misc queries) | |||
| need to make a cell with numbers ascend when printed in multiple? | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
