date format/charting issues

[Monty]

2006-02-03-01.48.09.698000

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

 

[Peo Sjoblom]

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