Endlessly repeating values

  • Thread starter Thread starter nickxylas
  • Start date Start date
N

nickxylas

I am working in a spreadsheet created by my predecessor at the state
agency where I work, and have come across a peculiar bug. In certain
cells, whenever I type in a value, then that value will repeat
endlessly. For example, if I type in "45", then Excel converts it to
"454545454545..." and so on ad infinitum. I have a fair amount of
experience with Excel, but have never seen it do this before, can
anyone suggest a way to turn it off?
 
Check
Format|Cells|Alignment tab
Do you have the horizontal alignment set to Fill?
 
Yes I did. Thanks for the prompt response. Nice to know about that
feature, even though I can't think of a situation in which I would
actually need to use it.
 
I think it may be a holdover from the old non-wysiwyg days.

If you wanted to "underline" a cell, you could fill the cell with a dash or an
equal sign.
 
You must log in or register to reply here.

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

Similar Threads

Need macro to delete rows not containing certain text 0
SUMIFS ONLY UNTIL the number REPEATS 1
Access Macro Repeat Expression using value of a field in table 0
Macro to insert a line when a value changes in a range 1
Endless Loop - Why? 2
Access Access - Is it possible to repeat fields in a form? 1
How do I fit a graph to data? 1
Calculate Stanine Values 6

Back
Top