View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Angie
 
Posts: n/a
Default how do i format date to say dd-mmm

I'm formatting a column for dates -- when I type in Apr 17 in a cell in that
column, I want it to show up as 17-Apr. Under formatting cells, I've found
it under English-US (dd-mmm), but when I click on that one, the date does not
show up correctly. When I type in Apr 17, it shows up as 1-Apr.