repeating text
 

I have a spreadsheet where text in column of cells started repeating in each
cell. No formulas are entered in any of the cells. For example cell B3
shows descriptiondescriptiondescriptiondescription when "description" is only
entered once. Cell B4 shows 42x10242x10242x10242x10242x102 when 42x102 is
only entered.
Any ideas?
--
todd fabman

repeating text
 

Have a look at the format in the cells. Is it *@ ?
Make it General
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"todd fabman" wrote in message
...
I have a spreadsheet where text in column of cells started repeating in
each
cell. No formulas are entered in any of the cells. For example cell B3
shows descriptiondescriptiondescriptiondescription when "description" is
only
entered once. Cell B4 shows 42x10242x10242x10242x10242x102 when 42x102 is
only entered.
Any ideas?
--
todd fabman

repeating text
 

In xl2003 menus:
Select the cell(s)
format|cells|alignment tab
Change the horizontal alignment to something besides Fill.

todd fabman wrote:

I have a spreadsheet where text in column of cells started repeating in each
cell. No formulas are entered in any of the cells. For example cell B3
shows descriptiondescriptiondescriptiondescription when "description" is only
entered once. Cell B4 shows 42x10242x10242x10242x10242x102 when 42x102 is
only entered.
Any ideas?
--
todd fabman

--

Dave Peterson