Thread: Date Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Qaspec Qaspec is offline
external usenet poster
 
Posts: 96
Default Date Format

I have a column with the date formatted as 8/11/08 in one column. In the next
column over i would like to show just the month anth the year as Aug 08. The
issue is each time i type this into a cell it returns 8-Aug which acutally
equals 8/8/08. How can i show just a month and a year based on the date in
another column?

Example
COL_A COL_ B
8/12/08 Aug 08
9/1/08 Sep 08
9/17/08 Sep 08