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

Formatting a Variable
 

Hi Arturo

A date variable does not contain any formatting, it does not contain any /
or - or . It only contains the real unformatted date, it's your computer
that formats its display. So you don't format the variable but its
representation wherever you see it displayed.

HTH. Best wishes Harald

"Arturo" skrev i melding
...
"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