Dash (-) causing error - How to fix it using batch macro?

[udles5666]

Hello Community 

I have an excel dataset with 50 tabs having 48 columns in each tab. The structure of the column doesn't change but, few values of a field have a - (dash) which i think is causing an issue for Dynamic input tool.  Can you please help me resolve this? I tried to build a macro but got stuck and couldn't figure out a way forward. Shall i be using a macro though for it? 

Appreciate help in advance. Workflow with dummy data attached. Thanks heaps :)

[Qiu]

@udles5666 
Really sorry about this.