//flex table opened by JP

Click to See Complete Forum and Search --> : Excel 2003 formatting problem


Kathleane
01-22-2007, 02:24 PM
I am using Excel 2003 to store information that I frequently send to employees by copying cells and pasting them into an email mssg. This has worked very well for years and now all of a sudden (can't think of anything I did to change this) when I paste cells into an email mssg all the text is vertical and therefore impossible to read. Here is an example:

T
o
r
r
a
n
c
e
$
1
2
/
t
r
a
v
e
l

I've tried changing the formatting on the rows and the sheet. I've tried copying the formatting from rows that do not do this and still I get this many times when trying to paste info into an email mssg. When I tried duplicating the problem in this mssg everything pasted fine so I had to manually duplicate the problem by hitting the Return key after each letter.

This does not happen if I paste only one cell at a time - but this is so tediuos that it's not really a workable solution.

Any ideas?

Sterling_Aug
01-22-2007, 03:40 PM
Have you checked the cell formats?

Highlight a cell or group of cells, right click, select format cells, then select the alignment tab. On the top right, you will see the orientation with the option to select the degress of rotation. Make sure it is set to zero for horizontal text and the text alignment horizontal option is set to what you want (left or right).

Kathleane
01-22-2007, 04:00 PM
Thanks for the suggestion. Yes I did check the formatting and the text orientation and all looks fine there. I even played with changing the horizontal alignment from General to Left, etc. but it had no effect.

rockinup1231
01-22-2007, 06:01 PM
If you have been using outlook, maybe there's a setting that will fix the problem there.

Kathleane
01-22-2007, 08:14 PM
Oh, I didn't mention the email program that I'm using. Pegasus vs. 4.3.1 and I haven't made any changes or upgrades to that program either.

I haven't checked to see if it happens when I use webmail or Outlook.

Wait. I just tried one more thing and it looks as if it took care of the problem. I saw that in Page Setup for the Excel worksheet the Scaling was set to 12% of normal size. When I changed that to 100% the problem is cleared up. Yea!