| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting a two-variable data table | Excel Worksheet Functions | |||
| Conditional Formatting using variable text | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| How to copy formatting when moving from cell to variable to another cell on another worksheet | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
Linear Mode
