Formatting a Variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

“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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Variable to someone 5
Variable Manipulation 2
Procedure level array not recognised at module level 2
Last Day of the Latest Month Syntax problem 5
Assign Selection to a Variable 2
How to Select A Cell in VBA with a Variable Row Number? 3
I need a variable name to contain the values of several cells 2
problem formatting a variable 1

Back
Top