date format/charting issues

2006-02-03-01.48.09.698000

I have a column that consist of a date/start time stamp (as shown above). I have changed the format of the column using custom that follows this format, however when I try to scatter chart this, I get at 1900-01-00, 1900-01-10 etc. for one of the axis. Any idea how to keep the original contents and why is it going to a 1900 year? Thanks in advance!

To me that is text format, I haven't seen any date time formats that looks
like that
obviously the 2006-02-03 is Feb 2nd 2006 but the -01 makes it text and what
is
01.48.09.698?

is it decimal time as in 1 hour and 28 minutes converted to time or is it 1
hour and 48 minutes?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Monty" <Monty.26h1hn_1145382902.1512@excelforum-nospam.com> wrote in
message news:Monty.26h1hn_1145382902.1512@excelforum-nospam.com...
>
> 2006-02-03-01.48.09.698000
>
> I have a column that consist of a date/start time stamp (as shown
> above). I have changed the format of the column using custom that
> follows this format, however when I try to scatter chart this, I get at
> 1900-01-00, 1900-01-10 etc. for one of the axis. Any idea how to keep
> the original contents and why is it going to a 1900 year? Thanks in
> advance!
>
>
> --
> Monty
> ------------------------------------------------------------------------
> Monty's Profile:
> http://www.excelforum.com/member.php...o&userid=33605
> View this thread: http://www.excelforum.com/showthread...hreadid=533856
>