Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
It's not a date or time.
Hi, I'm exporting data to Excel from another software program. When the data
is in excel, there is one column that contains numbers and colons (e.g. 10:10:80). Unfortunately for me, Excel sees this as an improper date/time entry and gives me a decimal number instead. Is there a way in Excel to get the program to recognize it (10:10:80) as text rather than a general number or date? I will eventually use text to column to get each number in its own column so I can use the numbers in calculations. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |