Formatting a date/time cell

I am trying to import/open a .CSV file in Excel that has date/time
information in one of the columns. In the .CSV file, this information is
represented as something like:

"10/04/2005 18:16:09"

When I open this file in Excel, apparently Excel is smart enough to "figure
out" that this is a date/time field, and it formats it as such. However, it
formats it as "mm/dd/yyyy hh:mm" -- with no seconds! They're just ignored.

Interestingly enough, if I click on any of those cells, and look at the data
displayed in the "fx" box at the top, it will say (using the above example):

10/04/2005 06:16:09 PM

So, in other words, the "seconds" data *is there*. I just can't get it to
display.

I've tried searching the Format options\ -- under Date, Time, and Custom
categories -- and can find all sorts of different manipulations of date and
time formats. But nothing that includes the date *and* the seconds. I can
either get the date and time (without seconds), or just the time (with
seconds).

If the complete data *is there* (which it obviously is), then how can I get
it to *display* as such, within each individual cell????
-----------------------------------------------------------------
Frank Nicodem
[email protected]

Use a custom format of

mm/dd/yyyy hh:mm:ss

HTH

Bob

"Frank D. Nicodem, Jr." <[email protected]> wrote in message
news:[email protected]...
>I am trying to import/open a .CSV file in Excel that has date/time
>information in one of the columns. In the .CSV file, this information is
>represented as something like:
>
> "10/04/2005 18:16:09"
>
> When I open this file in Excel, apparently Excel is smart enough to
> "figure out" that this is a date/time field, and it formats it as such.
> However, it formats it as "mm/dd/yyyy hh:mm" -- with no seconds! They're
> just ignored.
>
> Interestingly enough, if I click on any of those cells, and look at the
> data displayed in the "fx" box at the top, it will say (using the above
> example):
>
> 10/04/2005 06:16:09 PM
>
> So, in other words, the "seconds" data *is there*. I just can't get it to
> display.
>
> I've tried searching the Format options\ -- under Date, Time, and Custom
> categories -- and can find all sorts of different manipulations of date
> and time formats. But nothing that includes the date *and* the seconds.
> I can either get the date and time (without seconds), or just the time
> (with seconds).
>
> If the complete data *is there* (which it obviously is), then how can I
> get it to *display* as such, within each individual cell????
> -----------------------------------------------------------------
> Frank Nicodem
> [email protected]
>