View Single Post
  #6   Report Post  
lukas
 
Posts: n/a
Default

Ikke,

you can customize the date in Excel. Fromat cells (CTRL+1), Number tab, in
Category seelct Custom. The format of date as you mentioned enter in the Type
text files:
mmmm yyyy
mmmm stands for fully named monthy; yyyy stand for 4 digits year.

Enjoy!
--
Regards
Lukas Polansky


"Ikke" wrote:

Hi everyone,

I've just started using Excel for some small spreadsheet I need to have,
and I've stumbled upon a little problem.

Whenever I enter some text in a cell (for example August 2004), Excel
converts it to a 'date' format (aug/2004) which is not what I want.

How can I stop Excel from making these conversions, and tell it to keep
what I type?

Thanks in advance,

Ikke