If you preformat the cells as text, then you don't need to proceed the entry
with an apostrophe. Is that the simplification you are looking for?

Also, I agree with other posters that 02/2008 would mean to most people Feb
2008. First, why precede it with a zero? There are only 4 quarters in a
year. Additionally, something like 2Q2008 would be much more intuitively
recognizable to users.

Regards,
Fred.

"LiveUser" wrote in message
...
Is there any other way? This will be filled out from a lot of different
people and I am trying to keep it very simple, preferably pre-formatted.

"Peo Sjoblom" wrote:

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.