View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default I want quarters not months

Precede the entry with an apostrophe ' or format the cell(s) as text before
typing


--


Regards,


Peo Sjoblom



"LiveUser" wrote in message
...
I have a cell that I would like to enter 02/2008 referring to quarter/year.
Everytime I enter the information Excel changes it to Month and year. If I
format the cell for general information it changes it numbers.

Is there a quarter option?

No months will be entered into this cell. Just quarters and years.