Date numbers convert to formula

J

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.
 
K

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?
 
F

Frank Kabel

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

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.
 
F

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
 
K

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.
 
F

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
 
G

Gord Dibben

Jeff

Tools>Options>Transition

Uncheck "transition formula entry"

Also Uncheck everything else while you're there.

Gord Dibben Excel MVP
 
Top