Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have collected about 1000 points of data from the HyperTerminal program and
saved the data as two file formats one being .txt and the othet .csv. When I load the .csv file I am not taken through the wizard which is okay. When I load the .txt file I am. Anyways, my question is.. why will my cells not format? Currently this is what the cell looks like that i want to format "01/12/06 15:38:17" and there is one for every second for about 1000 seconds. Excel reads these cells as general cells, I am curious why I can not change them to a date format. The reason I want them to be a date format is because I will be graphing this informat and it needs to be acurate as I am writing a manual on how to setup a "Internal Data Logger for a portable D.O. analyzer" and how to send the information to a computer. Any help? Recap: Why will my date/time cell "01/12/06 15:38:17" not format to lets say "Thursday, January 12, 2006? I do believe the cells are locked.. but when I unlock them.. still nothing happens. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
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) |