Thread: format cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric
 
Posts: n/a
Default 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