Any code running that would do the deed?


Gord

On Tue, 12 Aug 2008 12:53:03 -0700, TheWanderer
wrote:

Hi
sorry but that isn't the answer cell is easily wide enough to take the
example several times over and this does not happen in 1 cell it occurs in
most of the cells in the sheet.

"Gord Dibben" wrote:

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