Hello Seniors,
I have created a sheet that extracts data from nseindia.com and automatically refreshes every 1 minute.
The sheet also pulls up dashes '-' which does not let me do automated calculations.
Please help me to change these dashes '-' to zero '0' automatically.
If I change them manually they again come up since it has to refreshing automatically.
I have attached snapshots.
Thanks,
Johnny
