Hi,
On export, I am getting extra info appended to the categories - I believe this may be the form field or reference number. I have categories set as numbers (for example - a category could be set as 0398) but it gets exported as that number plus a colon and number. 0398:3815 (I had to set up the categories several times, which could explain the high number appended). Each time the category is listed, the attached number is the same at least, but it's messing up reporting. The colon+number is preventing counting in Excel when we're trying to tabulate records.
Do you know what is causing this, and how I can turn it off?
thanks!