I have a Request Number that looks like this: PO-2019-06-03_073703. I inserted a formula to take out the hyphens and underscores, Replace(Replace([Request Number],"-",""),"_",""), to just leave PO20190603073703. I need to use the count of those Request Numbers in a Crosstab to show volume but it keeps throwing an error b/c it's a string and not a number. I've tried changing it to a fixed decimal, int, double, etc in the select statement but it won't seem to work. Any idea how I can get that string of letters and numbers to act like a number? The only other option I can think of is to remove the PO at the beginning.
