It's not a date or time.

M

Michi

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.
 
M

Michi

Thanks David. I am using a program that creates the Excel file, and it gives
me limited options to format the data prior to exporting. Is there a
solution for resolving my problem in Excel?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

elapsed dates between start and end date and time 2
Date separator 1
how can I save an excel file with long number columns in cvs form. 3
Find the position of a date 6
Add 45 days to a date.... 3
find first positive number in column 7
Date Difference 2
Summing the number of incomplete jobs within a date range -sumprod 6

Top