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!


--
Monty
------------------------------------------------------------------------
Monty's Profile: http://www.excelforum.com/member.php...o&userid=33605
View this thread: http://www.excelforum.com/showthread...hreadid=533856

date format/charting issues
 

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" wrote in
message ...

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