Duplicate Words in a Cell

S

suz

Has anyone ever encountered the following: entering text into one cell &
when you hit enter the words automatically duplicate, e.g., let's say you
type the words "brown dog" in cell A2 and when you hit the enter key you
would get "brown dog brown dog" in cell A2. This doesn't happen in other
columns already in the worksheet or columns you add, just that particualr
column.

If you have encountered this problem, please tell me how it happened and how
you corrected it.

Thank you.
 
R

Ron Coderre

If there are no macros effecting the change,
check the Number Formatting for those cells.

From the Excel Main Menu:
<format><cells><number tab>

I suspect you'll find it's:
Category: Custom
Type: @@

If you want all entries to be text,
change the settings to:
Category: Text

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)
 
G

Gord Dibben

Is that column formattted to Alignment>Horizontal>Fill


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top