View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Box666 Box666 is offline
external usenet poster
 
Posts: 29
Default Date shown as just month and year

In column D I have a date in the standard format of 22/02/2008, in
column K i would like that date to be displayed as the month and
year. So in this case "Feb 2008"

I believe i can just add a simple formula that will lookup the date in
column D and display it as requested.

Could anybody assist please.

With thanks

Bob