Search code examples
excelformatexcel-2013

Text in cell repeats or doubles, why?


I typed in =NOW() and the cell displayed "1/6/20161/6/2016".

Checked cell format and conditional formatting and nothing seems amiss. What can cause this?

edit: as shown in the image below, I cannot recreate the anomaly outside of this column. Whether I copy/paste or type in =NOW() the result is the same. Screenshot


Solution

  • This is caused by setting the Text alignment Horizontal property to "Fill" in a cell that is sufficiently wide enough to allow the text string to be displayed twice.

    This is why in the screenshot columns B:C do not display the date twice; they have a lesser column width.