Form in Excel

  • Hi


    I have been trying to create a client file where client information is saved like name , date of birth , postcode , email etc . Since these are filled on the go, I need to format fields in a way that information typed get converted to the way I want to see, like name typed in any way, all capitals, First letter capital etc gets converted to Sentence Uppercase i.e. First Letter of a word is capitalise and this happens for every word after a space. Date in number format dd/mm/yyyy Post code in the format of capital letters.


    I don't know how individual cells can be formatted this way, please help me as I don't want to run a VB code.


    Thanks:)

    Ankit