Here is a neet trick,
Highlite the range you want to transpose and go to eddit=find
enter the equals sign =
and then click replace, replace with the quotes sign "
replace all, now the cells are text
copy and transpose to where you want and then go to edit =Find
Find the quotes " replace all with the equals sign =
your formula has not changed


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=526340