Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello. I have imported some data into Excel. One of the columns represents
time and looks like this: "2008-02-14 15:40:07,734". I do a find-replace to replace all ',' in this field with '.'. Whenever I do this, however, Excel converts all of the data in this field to some sort of time representation. This is not what I want. I just want the original text as it was. I have tried setting the field to General and Text formats, and Excel still does the strange time formatting after Find/Replace. After the conversion, I've tried setting the field to Text, and I just get some silly time representation that looks like this: "39492.6528672917" Does anyone know how to turn off this autoformatting? I've looked all over hte options and can't find anything. Thanks, Lucas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete unwanted data | Excel Worksheet Functions | |||
Formatting time from imported data | Excel Discussion (Misc queries) | |||
Time formatting:data 1:30:20 entered reads in 1:30:20 pm | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |