Date numbers convert to formula

[Jeff]

When I input the string 4/9/4 into a cell having a date
format of dd/mm/yy, Excel first converts the entry into
the formula =4/9/4 (or 0.111111) and then converts the
result into the date 01/00/00. I assume I need to change
a setting somewhere to get 04/09/04, but I have grown
weary of looking for it.

Thanks.

 

[kkknie]

The only way I can get that to happen is if I type in =4/9/4 into th
cell. You should be typing 4/9/4 (no equal sign).

Maybe?

 

[Jeff]

I'm not typing the equal sign. Excel is adding it.

 

[Frank Kabel]

Hi
try:
goto the menu 'Tools - Options - Transition' and uncheck the
alternative key '/' (not sure about the translation of this option
though)

 

[Jeff]

That didn't work. Anything on this sheet that looks like
a formula is converted into one as if there is some auto-
recognition feature enabled. i.e. if I type "2+3" Excel
is adding the equal sign and giving me 5. The problem
only occurs on one sheet in the workbook.

 

[Frank Kabel]

Hi Jeff
can you check if there's an event procedure enabled?
- right-click onf the tab name
- choose 'Code'
- check if there's some code behind this sheet

 

[kkknie]

Right click on the worksheet tab and select View Code and see if ther
is anything in there starting with Private Sub Worksheet_Change(ByVa
Target As Range)

If so, you have a macro adding the = to your entries.

 

[Guest]

There is no Code behind any of the sheets or in any modules.

 

[Frank Kabel]

Hi
and this problem happens only on one sheet in this workbook?
If yes you may email me the file and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de

 

[Gord Dibben]

Jeff

Tools>Options>Transition

Uncheck "transition formula entry"

Also Uncheck everything else while you're there.

Gord Dibben Excel MVP