How do I format Connector values in Microsoft Word

Transform Caseware Connector values in Microsoft Word by adding custom character formatting to the cell calculation. This can be used to present numbers in a neater presentation, such as 10000 to $10,000.00.

1. Insert data by selecting the Caseware Linkage icon

2. Right click the cell and select Toggle Field Codes

3. Change \* Charformat within the cell calculation and use \# “NUMBER FORMAT” in addition to the table below.

Character	Note	Use Cases
#	Returns a number or a blank space in the absence of a number	Eg. 10000  Syntax: #####
0	Returns a number 1-9 if possible, otherwise 0	Eg. 10.00 Syntax: ##.00
$	Adds a dollar sign to the assigned position	Eg. $10 Syntax: $##
+	Returns a positive sign for any cell greater than zero	Eg. +10 Syntax: +##
–	Returns a negative sign for any cell less than zero (number must be negative)	Eg. -10 Syntax: -##
.	Adds a decimal point to the assigned position	Eg. 10.00 Syntax: ##.00
,	Adds a comma to the assigned position	Eg. 10,000 Syntax: ##,###
;	Allows multiple formatting options for positive, negative and zero numbers.	Eg. +10.00, (10.00), 0.00 Syntax: +##.00, (##.00), 0.00
text	Returns text in the string	Eg. 10 Dollars Syntax: ## ‘Dollars’

Example: Adding $ and two decimal places 

Change \* Charformat to \# "$###,###.00"

3. Right click the cell, select Toggle Field Codes.

4. Select Tools > Recalculate or F9. The updated formatting will now reflect in the calculation.

• Related Articles

• Can CaseWare documents be exported to Microsoft Word & Excel

  CaseWare Working Papers allows users to export CaseWare type documents to Microsoft products. Automatic Documents can be exported to Microsoft Excel. CaseView Documents can be exported to Microsoft Word. Automatic Documents To export automatic ...

• How to Export the Financial Statements into Microsoft Word

  To export Financial Statements to Microsoft Word, follow the procedure below: 1. Open your Financial Statements. 2. From the File tab, select Export > Rich Text Format. 3. In the File Name enter the name of the RTF file. 4. Click Save.   

• What is CaseWare Connector

  Connector is an add-in for Microsoft® Word and Microsoft® Excel® that enables you to link data between Working Papers and Microsoft documents. The Connector Add-in appears as its own toolbar in Microsoft® Word and Microsoft® Excel®. Using ...

• Connector Getting Started 6: Using Connector with Microsoft Word

  Similar to Excel, Connector can be used on all your Word engagement documents to auto populate templates specific to each engagement.

• How do I send a document to an external reviewer if they do not have Connector

  The Unlink option enables you to embed the current value of links within the document, effectively replacing the linkage formula with its value instead. When unlinking a document, the current values remain in place and the document becomes an ...