Excel Sheet Correction

[johnny03]

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

[Admin]

Let us show the calculation formulas.