I all,
I would like to have the cell formatted MM/DD/YYYY.
Is it possible to format or to use VBA, if I in the cell will enter for example 040512 (no slashes), after finishing the entry, it will show 04/05/2012, if I enter 100421 (no slashes), after finishing the entry, it will show 10/04/2021.
Thank you in advance
I would like to have the cell formatted MM/DD/YYYY.
Is it possible to format or to use VBA, if I in the cell will enter for example 040512 (no slashes), after finishing the entry, it will show 04/05/2012, if I enter 100421 (no slashes), after finishing the entry, it will show 10/04/2021.
Thank you in advance