hi all,
I am attaching an excel sheet which pull up the real time data from nifty about options.
This is a hcltech options chain data sheet.
I want all the cells displaying "-" to changed to 0 automatically.
the sheet is auto refreshing, if I change it manually, they again change back to - after refresh.
file link at 4shared
/file/bKtQdDJcce/hcl_sheet.html
please help
i have attached screenshot highlighting the cells which should change to 0
thax all ,aman
I am attaching an excel sheet which pull up the real time data from nifty about options.
This is a hcltech options chain data sheet.
I want all the cells displaying "-" to changed to 0 automatically.
the sheet is auto refreshing, if I change it manually, they again change back to - after refresh.
file link at 4shared
/file/bKtQdDJcce/hcl_sheet.html
please help
i have attached screenshot highlighting the cells which should change to 0
thax all ,aman
Last edited: