exel date formet

[puneet_pr]

we r using exel 2007 where we hav dates

mm/dd/yy
dd/mm/yyyy
dd/m/yyyy


we want dd/mmmm/yyyy formet

 

[GopalaKrishnaJ]

Lets Thinks i've a value in Cell A1-->6/18/12

From excel use =Text("A1","dd/mmmm/yyyy")
From vba use--> range("A1").numberformat="dd/mmmm/yyyy"

 

[Robert Mika]

Or you can use Custom Format.Right Click on the cell--Foramt Cells-->Number--Custom-->dd/mmmm/yyyy