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 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