automatic formatting

L

Larry Gagnon

When I answer "Y" to a question in an Excel program that I wrote, the
program enters "YYYY".
How can I turn off this "automatic formatting"?
 
D

Dave Peterson

You're typing this in a cell?

First, what do you see in the formulabar after you've typed your entry?

If you really see multiple Y's:

I'd check the keyboard to make sure it's not sticking.

I'd check tools|autocorrect options|autocorrect tab
to make sure that the Y isn't being replaced with YYYY.

I'd check tools|options|edit tab|uncheck Enable autocomplete for cell values
(maybe excel is autocompleting the y's based on an entry in a close cell in that
column)

If you only see a single Y in the formula bar:

I'd check the format of the cell
Format|cells|Alignment tab|horizontal
Is Fill chosen? If yes, try General.
 
Top