To TCVN3

Location on ribbon: Tab DVD Addin → Group Text and Number

Command ID: btnConvertTCVN3

What it does

Converts Vietnamese text in the current selection to the TCVN3 (ABC) encoding and sets the font of the converted cells to .VnTime. Use it when a document has to be returned in the exact format of an old official template — estimate forms, quantity schedules or acceptance records issued years ago that still mandate the .VnTime font family.

How to use

1. Select the cells to convert (Ctrl-click for several separate areas).
2. Go to tab DVD Addin → group Text and Number → click To TCVN3.
3. The add-in detects each cell's source encoding from its font (.Vn… = TCVN3, VNI… = VNI, anything else = Unicode) and rewrites the text as TCVN3.
4. Converted cells are switched to the .VnTime font.
5. The status bar reports Converted N cells to Tcvn3 (font: .VnTime) and clears after about 8 seconds.

Example

An annex of quantities written in Unicode has to be pasted into a legacy .VnTime form. Select the description column and click To TCVN3:

Before (Unicode)	After (TCVN3 bytes, .VnTime font)
Đào móng bằng thủ công	§µo mãng b»ng thñ c«ng
Trát tường trong dày 15mm	Tr¸t têng trong dµy 15mm
Lắp dựng cốt thép cột	L¾p dùng cèt thÐp cét

Displayed with the .VnTime font these strings read as the original Vietnamese.

Notes

• TCVN3 has no full set of accented capitals; all-caps headings (for example "BẢNG TỔNG HỢP KHỐI LƯỢNG") usually need manual fixing with the .VnTimeH font after conversion.
• Formula cells are skipped; only text values are re-encoded.
• The change cannot be undone with Ctrl+Z — keep a copy before running it on an official document.
• The machine opening the file must have the ABC (.VnTime) fonts installed, otherwise the text looks corrupted.
• With no range selected the add-in shows "Please select a data range." and stops.

Related

• To Unicode — bring TCVN3 documents up to Unicode for calculation, lookups and email.
• To VNI — the other legacy encoding still found in older estimate templates.
• Convert encoding — dialog version with scope selection and a skip-formula option.
• UPPERCASE — adjust letter case once the encoding is consistent.