Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quick way to convert exported text to dates 1

Status
Not open for further replies.

eggohead

Technical User
Oct 19, 2003
25
US
Hello, I have a huge list of data that was exported into a spreadsheet. The dates appear to be in text in the following format:

12/11/08 06:37
12/11/08 16:33
12/12/08 09:35
12/12/08 11:45

How can I quickly covert all of these values to dates? If I enter the cell and click enter it gets converted to a date but thats tedious for thousands of rows of data.

Any suggestions?

- Thanks
 


Hi,

Use Data > Text to columns... and parse with the appripriate date conversion option.

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 


a second method.

enter the value 1 in an unused cell.

COPY the value

Select the range containing the imported date/time text

Edit > Paste Special -- MULTIPLY

VOLA, y'all!

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top