Changing text automatically

K

kerryzanne

After typing in AUGUST 2004 my text automatically changes to
Aug-04. Is there something in Excel which prohibits typing the ful
month? Any help gratefully received
 
D

DanH

Have you tried to right click the cell and click format
cell. Then select Date and on the right side box select
the format you want?
 
A

Allan Koodray

Try typing 'August 2004 or format the text as text prior
to entry (Format -> Cells... -> Number -> Text)

Allan
 
G

Guest

Hi

If you format the cell first as mmmm yyyy You can then type Aug 04 and
it will display it as August 2004
 
D

Dave Peterson

I'd enter the day portion of that date, too. Just so excel (and I) don't get
confused.
 
Top