Excel wont recognise date format

  • Thread starter Thread starter Fendi Baba
  • Start date Start date
F

Fendi Baba

I export a set of data from SQL and have a column showing dates. An
example of this format is
5/13/2007 6:19:07 PM which is May, 13 2007. I need to format this
column to show just the date without the time element. but excel wont
recognise this as a date. How can I work around this?

Thanks for your kind advice.


Regards
 
Frendi,

It sound like the *Date* is actually time try:

=INT(A1+0)
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
=DATEVALUE(LEFT(A1,10))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I export a set of data from SQL and have a column showing dates. An
| example of this format is
| 5/13/2007 6:19:07 PM which is May, 13 2007. I need to format this
| column to show just the date without the time element. but excel wont
| recognise this as a date. How can I work around this?
|
| Thanks for your kind advice.
|
|
| Regards
|
 
=DATEVALUE(LEFT(A1,10))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I export a set of data from SQL and have a column showing dates. An
| example of this format is
| 5/13/2007 6:19:07 PM which is May, 13 2007. I need to format this
| column to show just the date without the time element. but excel wont
| recognise this as a date. How can I work around this?
|
| Thanks for your kind advice.
|
|
| Regards
|
Click to expand...

Thanks.

I will give it a go. At the moment I also face the the problme that
excel tries to recognise the first date portion as days instead of
months.
 
You probably have a .csv file. If so, rename it a .txt file. On opening, you'll get a wizard in which you can specify the correct
date format.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| > =DATEVALUE(LEFT(A1,10))
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > |I export a set of data from SQL and have a column showing dates. An
| > | example of this format is
| > | 5/13/2007 6:19:07 PM which is May, 13 2007. I need to format this
| > | column to show just the date without the time element. but excel wont
| > | recognise this as a date. How can I work around this?
| > |
| > | Thanks for your kind advice.
| > |
| > |
| > | Regards
| > |
|
| Thanks.
|
| I will give it a go. At the moment I also face the the problme that
| excel tries to recognise the first date portion as days instead of
| months.
|
|
 
Back
Top