Posts by LAS

    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:

    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':(