Data Import: treat a dash a zero
Hi Is it possible to treat a dash/hyphen as a zero during a data import from a file? Thanks, Mark
Forum Discussion
You could through a rule on the Amount field, but in an attempt not to go that route you could try to Substitution settings on the Data Source Amount field. I have not tested this particular situation though.