Select the column, from the menu on the Format> Cell, appear Format Cells
window select the Number tab, for Category select Custom, in the Type in dd-
mmm-yy and press the OK button.
2013/3/12 Hilary Lomotey
> Hello Gurus,
>
> kindly help on the subject above. i need the users to enter dates in
Hello Gurus,
kindly help on the subject above. i need the users to enter dates in the
format dd-mmm-yy, i tired text(a1,"dd-mmm-yy") in DV ,all custom but its
not working. thanks
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Fac