View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
deko[_3_] deko[_3_] is offline
external usenet poster
 
Posts: 62
Default Formatting and sorting cells with VBA

will repost this as new question...

"deko" wrote in message
m...
By the way, the reason for the text field (rather than date) is because

the
chart that is created from this data gets it X-axis labels from the column
with the date values - and only the date (10/12/2004) shows in the X-axis
rather than the date and time (10/12/2004 13:23) when the columns is
formatted as date. With a string, I get the time as well as the date.