View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arturo Arturo is offline
external usenet poster
 
Posts: 108
Default Formatting a Variable

€śEndDate = Range("H1").Value€ť
10/18/04 gets assigned to EndDate.
I can dump that to a cell and replace €ś/€ť with anything else.
How can I replace the forward slash, re-formatting that variable within this
procedure?

Thank you,
Arturo