Cell changes alignment after data entry

H

Howard Moore

When I select a row and enter data with Excel 2002, some
of the cells change alignment to centered from not
centered upon hitting Enter. This problem did not occur
on the same worksheet using Excel 2000.

Any idea why, or how to prevent? My updates are current.
 
D

Dave Peterson

What did you type into the cells?

If you started with ^ (caret) and you have tools|options|transition
Tab|transition navigation keys checked, you'll get this behavior (it's to match
what Lotus 123 accepted).

(and you don't have any event macros running and the cells aren't formatted as
Centered???)
 
Top