S
Spike
I have a problem formatting a variable.
if i place the following in a sub the variable value does not change; it
stays as "dd/mm/yy"
dim datCFwd as date
datCFwd = Sheets("Model").Range("Model_AccountingEnd").Value
datCFwd = Format(datCFwd, "dd mmm yy")
however if i pass this variable to another sub and run the same formatting
code the variable is changed to how i want it.
The Range("Model_AccountingEnd") is formatted as a Custom format "dd-mmm-yy"
and it does appear in this format on the relevant sheet.
if anyone has any ideas why this should be i will be very interested
if i place the following in a sub the variable value does not change; it
stays as "dd/mm/yy"
dim datCFwd as date
datCFwd = Sheets("Model").Range("Model_AccountingEnd").Value
datCFwd = Format(datCFwd, "dd mmm yy")
however if i pass this variable to another sub and run the same formatting
code the variable is changed to how i want it.
The Range("Model_AccountingEnd") is formatted as a Custom format "dd-mmm-yy"
and it does appear in this format on the relevant sheet.
if anyone has any ideas why this should be i will be very interested