View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
m_karbala
 
Posts: n/a
Default ss:Formula in excel saved in xml format


Hi,

I can think of 2 cases:
1- If you have your formula in the <dataType="string"""your formula""
</Data element then it will be appear as a string.
2- If you have it as a ss:formula then check your styles. It is
possible that in you style the format of the cell is text. Even thought
it will give you an error and won’t show your formula at all in excel.


--
m_karbala
------------------------------------------------------------------------
m_karbala's Profile: http://www.excelforum.com/member.php...o&userid=27555
View this thread: http://www.excelforum.com/showthread...hreadid=507287