Excel sheet for data, Dataformat Error for character "-"

[billymild]

Most of the entries on this column on the Excel sheet are actual decimal numbers, but a lot just have the character "-". I would like to make this 0 instead of "-". Is there an easy to do this? 

[Daryl-Lynch-Bzy · Accepted solution]

Hi @billymild, please use "Replace Value" to change the "-" to "0".  You will find this function on the menu bar.

[billymild]

I  tried that at first and it doesn't recognize the "-" as a value. 

[AlexisOlson]

That's because your column type is numerical. Load it as a text column, do the replacement, then convert it to a numerical column.