After entering a date Jan 2002, Excel automaticly changes it to a date format Jan-02.
Is it possible to format the date as JAN-02 i.e. Upper case, without a formula.
Thanks
After entering a date Jan 2002, Excel automaticly changes it to a date format Jan-02.
Is it possible to format the date as JAN-02 i.e. Upper case, without a formula.
Thanks
Thanks Hans and Dennis,
It is not quite what I need. I have resorted to the UDF for now, but I was trying to avoid it so that users would not have to enable macros just for this function. (I have no other macros in this workbook.)
Also I am not looking for the workbook or path. I am looking for the LAST folder in the path.
eg: IN C:>My documents>Clients>Subfolder 1>Subfolder 2>Subfolder 3>File.xls
I want to return just 'Subfolder 3'.
Not so easy!:lol:
BTW: How do you post a backslash? It doesn't come out:mad:
The answer isn't so easy. I want just the parent folder name, not the whole path or the workbook name.
Thanks
Can some one help me identify the partent folder name of the current open workbook via a formula.
eg: c:\My documents\Clients\Analysis\Reports\Rep1.xls
I want to get the parent folder name i.e
'Reports':(