If you use either shg's suggestion or mine (mine pretty much uses a helper column, shg's does not), they both convert whatever is in that cell to a value