Excel is trying to be helpful!

You can't turn this off. What you can do is either preformat the cell as
TEXT before you type in the data or, precede the data with an apostrophe
like this: '1/08. The apostrophe will not be displayed in the cell.

--
Biff
Microsoft Excel MVP


wrote in message
...
Hi,

first of all, I am an absolute excel novice and never used it until
today, so, forgive me if my question is stupid (for an
experiencedExcel user)

OK, the problem is simple, I want to insert the following value into a
cell: 1/08 . But excel changes it always into a date. It becomes "01
Aug", and if I double click on it, it becomes "01.08.2009". How to
stop this auto-correction?

My "1/08" is not a date, but a transaction number, so a auto
transformation of that value is not wanted.

I am using Excel 2007