ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   received "a=formula" instead of =formula after exporting data - wh (https://www.excelbanter.com/excel-worksheet-functions/128665-received-%3Dformula-instead-%3Dformula-after-exporting-data-wh.html)

Jane

received "a=formula" instead of =formula after exporting data - wh
 
I exported data into excel from an excel based report and instead of my
formulas coming over as 'noraml' ie =cell, it came over as "a=cell"

I simply replaced the "a=" with "=" and the formulas work so that is not a
problem. Just wanted to understand what the "a" means and why it happened.

thanks in advance, jane


All times are GMT +1. The time now is 01:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com