View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Singmin Michael Singmin is offline
external usenet poster
 
Posts: 60
Default Format Date in Chart Title

Hello group,


In Cell B2 I have 3-Oct-04

My code is as follows
With Sheet1.ChartObjects(1).Chart
.ChartTitle.Text = DateValue(Range("B2"))
End With

The Chart title displays 10/3/04
How can I get it to display 3/10/04 ?

Thanks

Michael Singmin