How wide is the column with AName?

If narrow, wrap text and autofit will result in your example.


Gord Dibben MS Excel MVP

On Tue, 12 Aug 2008 02:10:01 -0700, TheWanderer
wrote:

Hi, sorry if this has come up before but I have a problem with my excel sheet
that I use to store/collate my data for work.

Recently (past 2-3 days) the cells have started to display data in a
peculiar manner.

my data is entered into the cell as a mixture of text and numbers across the
cell with the word wrap on some of the borders are formated, there are no
formulae in the individual cells.

however over the past days the formatting of the data has changed in that
the text now runs verticaly down the cell e.g.

from AName
to
A
N
a
m
e
I hasten to add this is not a function of the text direction function of the
format menu

Does anyone have any suggestions as to a permanent fix?

thanks