View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bretp bretp is offline
external usenet poster
 
Posts: 2
Default 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.