transpose - array problem
 

I'm trying to use the transpose function. When I hit ctrl-shift-enter after
F2 I get a formula error dialog. Upon closer inspection and testing a period
appears after the transpose function in the cell after the ctrl-shift-enter
combination.

This is Excel 2003 in Windows XP environment. It appears to be machine
specific because I copied the spreadsheet to my laptop which is running Excel
2002 and was able to get the transpose to work. When I move it back to the
original computer it is fine.

Thanks.

transpose - array problem
 

You may get better responses if you post the range getting the formula and the
formula you're using.

bretp wrote:

I'm trying to use the transpose function. When I hit ctrl-shift-enter after
F2 I get a formula error dialog. Upon closer inspection and testing a period
appears after the transpose function in the cell after the ctrl-shift-enter
combination.

This is Excel 2003 in Windows XP environment. It appears to be machine
specific because I copied the spreadsheet to my laptop which is running Excel
2002 and was able to get the transpose to work. When I move it back to the
original computer it is fine.

Thanks.

--

Dave Peterson