Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting a variable problem
I nave a problem formatting a variable. If i run the following in a sub it
has no effect on the variable value, howeverif i pass the variable to another sub and run the same formatting code on it it does it as i want. Dim datCFwd As Date datCFwd = Sheets("Model").Range("Model_AccountingEnd").Value datCFwd = Format(datCFwd, "dd mmm yy") the range Sheets("Model").Range("Model_AccountingEnd") is custom formatted as "dd-mmm-yy" but the variable actuallly holds the value as "dd/mm/yy" and this does not change unless it is passed to another sub as explained above Any ideas to correct this will be very gratefully received. -- with kind regards Spike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting using variable text | Excel Discussion (Misc queries) | |||
formatting a variable | Excel Programming | |||
Set formatting variable | Excel Programming | |||
Formatting a Variable | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |