I have a field in an Access table that is set to TEXT. The records in the field are a combination of "N/A" and unformatted numbers (ie, 125874). I need the field to have "N/A" when there is no applicable value but I would also like when there are numbers to show with commas (i.e. 125,874). I don't need a $ sign and i do not need the numbers to add up, hence why a text field works. the comma is just for display purposes. Is there come INSTR formula I can use when a number exists in the field?