Excel rewrites formula

[Harvey Waxman]

The validation formula I enter in a cell is =ISNONTEXT(E3) but when I
check validation later it shows: =ISNONTEXT(E3)e

Where does the "e" come from? If I delete the 'e' it comes back when I
next check it.

Excel OfficeX Leopard

 

[Bob Greenblatt]

The validation formula I enter in a cell is =ISNONTEXT(E3) but when I
check validation later it shows: =ISNONTEXT(E3)e

Where does the "e" come from? If I delete the 'e' it comes back when I
next check it.

Excel OfficeX Leopard

Beats me. did you check your auto correct entries?

 

[Harvey Waxman]

Beats me. did you check your auto correct entries?

I did. There is nothing in there that remotely resembles the formula
entry. Excel insists on adding the 'e' only to this formula. Is there
any way to correct it?

 

[Bob Greenblatt]

I did. There is nothing in there that remotely resembles the formula
entry. Excel insists on adding the 'e' only to this formula. Is there
any way to correct it?

Well, I'm sure there is, but I don't know how, as I don't know what is
happening. That formula works fine for me. So, if you edit out the e and
press enter the e returns?

 

[Niek Otten]

Does the formula work correctly? What do you see in the worksheet: the formula or the result?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In article <C49B6AE5.AE62D%[email protected]>,
|
| > On 7/10/08 6:24 AM, in article
| > (e-mail address removed), "Harvey Waxman"
| >
| > >
| > >
| > > The validation formula I enter in a cell is =ISNONTEXT(E3) but when I
| > > check validation later it shows: =ISNONTEXT(E3)e
| > >
| > > Where does the "e" come from? If I delete the 'e' it comes back when I
| > > next check it.
| > >
| > > Excel OfficeX Leopard
| > Beats me. did you check your auto correct entries?
|
| I did. There is nothing in there that remotely resembles the formula
| entry. Excel insists on adding the 'e' only to this formula. Is there
| any way to correct it?

 

[Harvey Waxman]

Does the formula work correctly? What do you see in the worksheet: the
formula or the result?

It doesn't work correctly.

I've changed it to =istext(e3) which stays the way it should and does
actually work properly. (the validation syntax seems the opposite of
what I'd expect but that's probably just me)

 

[Harvey Waxman]

Well, I'm sure there is, but I don't know how, as I don't know what is
happening. That formula works fine for me. So, if you edit out the e and
press enter the e returns?

Exactly.

 

[Bob Greenblatt]

Exactly.

Have you restarted Excel and you machine since this began? If so, does it
still happen? Does it happen on more than one worksheet or workbook?

 

[Harvey Waxman]

Have you restarted Excel and you machine since this began? If so, does it
still happen? Does it happen on more than one worksheet or workbook?

Good questions. I have restarted Excel but I'll try the others and let
you know.

 

[Harvey Waxman]

Good questions. I have restarted Excel but I'll try the others and let
you know.

New workbook is the same
Restart does make a difference. It adds a T at the end! I just will
have to never use that validation. I'm sure I can live without it.

Thanks

 

[Bob Greenblatt]

New workbook is the same
Restart does make a difference. It adds a T at the end! I just will
have to never use that validation. I'm sure I can live without it.

Thanks

OK, so now after you have restarted both the machine and Excel,
isnontext(e3) becomes isnontext(e3)t. Is this correct? What happens when you
reference another cell? Is is just isnontext, or does any function
referencing e3 cause the problem?

 

[Harvey Waxman]

OK, so now after you have restarted both the machine and Excel,
isnontext(e3) becomes isnontext(e3)t. Is this correct? What happens when you
reference another cell? Is is just isnontext, or does any function
referencing e3 cause the problem?

Isblank doesn't do it but isnumber does and it isn't related to E3. I
put the validation into a different cell (new workbook) and it added the
't' I then copied/pasted the validation of that cell to another cell
where it added the 'e' not the 't'.

I could go through lots of functions but I doubt that identifying which
ones would solve the problem.

I don't use validation often so this issue could be very old. I also
notice that lately Excel needs to be force quit more often. Clearly
there is some corruption somewhere. Maybe a re-install (if I can dig up
the original Office X cd.)