| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format cells
i copied data from the txt file into excel, i got 2 colunms, one was
-000:00:00( it is negctive) and other one was 0.1, 0.2.....999.9(from first row to last row), these two colunms were the time mark, the first one is the hours, minutes and second, the second colunm is the mSecond, i'd like to combine them into one colunm, but i cannot, excel didnot identify the first colunm is time. anyone can help me? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
| format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
| How do I get brackets in format cells accounting? | Excel Discussion (Misc queries) | |||
Threaded Mode
