View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter
 
Posts: n/a
Default Formatting of dates into quarters

Hi folks,

how can I change a concrete date, e.g. 21.02.2006 (typical German format)
into a quarterly view, e.g. Q1 2006 by using a custom number format?

It is essential for me not to use some kind of formula but to simply create
a number format that the user can select.

Thanks in advance.