S
SF
Hi,
I have an Access query that can be exported to Excel. The 4th column of the
query is the formular. But when export to excel, excel did not treat the 4th
column as formular (it display the entire content, could be as text)
ID Amount Qty Formular
1 8.99 55
2 8 2 =[A1]*[B2]
Is there any special character to be put in front of the cell for Excel to
reconigne as formular?
SF
I have an Access query that can be exported to Excel. The 4th column of the
query is the formular. But when export to excel, excel did not treat the 4th
column as formular (it display the entire content, could be as text)
ID Amount Qty Formular
1 8.99 55
2 8 2 =[A1]*[B2]
Is there any special character to be put in front of the cell for Excel to
reconigne as formular?
SF