View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Monty
 
Posts: n/a
Default Date format problems


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=533855