View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default How to store formula in Access table ?

The formula will come back as text. You need to reformat the cells to
general, and then do a find replace on the = sign to activate the formulas...
--
HTH...

Jim Thomlinson


"kleysonr" wrote:

Hi

I have a table in Access and some fields have formula's stored.
Using 'Get External Data' in Excel, i need that the formula stored become in
a formula in Excel and not just a string.

How can i do it ?