I'm using Monarch Pro 8.01 and I have a numeric field containing 4 digits in each row. Is there a way to add a letter to the beginning of this 4 digit number as Excel does with the Concatenate function =concatenate("C",CODE)?
i.e. CODE: NEWCODE:
Thank you! [/b][/quote]Yep!
Create a calculated field called Newcode (or whatever you want to call it), which will be a CHARACTER field (it cannot be a numeric field) and use this formula;