Refusing to Date Format

B

broux

When I retrieve a column of dates from a web query into Excel, it
returns the following:

2007-02-16 15:31:26
2007-02-16 15:39:18
2007-02-16 15:49:42
2007-02-16 15:40:02
2007-02-16 16:00:03

No matter how I try to format it, it refuses to accept the date
formatting. Tried formatting the cell. Tried paste special -
format. By accident, I hit F2 to edit the cell, and simply hitting
Enter, the date format changes to

2/16/2007 15:19

When I accidentally activated the cell, Excel recognized it as a date
and turned it into something useful. So, what is going on - and what
can I do to convert these seemingly nonsensical dates into a format
Excel recognizes as a date?
 
V

vezerid

You have text, not dates. Copy a blank cell, select the cells with the
dates, and Edit|Paste Special... choose Add. This will convert them to
numbers. Format to suit.

HTH
Kostis Vezerides
 

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

Copy value according to date 1
Highlight date nearest to TODAY() 4
convert text to date 3
How to retrieve a value based on 2 different criteria 2
Reducing duplicate courses to totals of each day 3
Chart and date data 2
Finding dates without attention to data formats 1
Max Min Differnce in a Range 6

Top