If you create a DME (Query) in MS Add-Ins with a status field and want to convert the numeric value to the actual description, save your DME file and then open it in TextPad (or Notepad, etc.) and edit the .dme file to add ,xlt to the status field. Save it and when you open it within MS Add-Ins and run it, the results will come back with the status description.
DEVEL2B~PO~PORECEIVE~2~1~600~Created with Query Wizard 10.0.109~0~1~0~F
LWSN104~~COMPANY~2~~PO-NUMBER~0~~REC-NUMBER~2~~STATUS,xlt~2~
NEW~~0
Sheet1~A~1~TRUE~FALSE~FALSE
Before:
| CO | PO-NUMBER | STATUS | |
| 6000 | 60000000000301 | 139 | 9 |
| 6000 | 60000000000300 | 138 | 9 |
| 6000 | 60000000000274 | 137 | 1 |
| 6000 | 60000000000275 | 136 | 1 |
After:
| CO | PO-NUMBER | ||
| 6000 | 60000000000301 | 139 | Archived / Closed |
| 6000 | 60000000000300 | 138 | Archived / Closed |
| 6000 | 60000000000274 | 137 | Released |
| 6000 | 60000000000275 | 136 | Released |
