Fixing the issue of periods converting to commas when opening in HTKK from an Excel file?

Buzz

Ngày cập nhật gần nhất: 15/4/2026

I am currently using Excel 2010 to read tax declaration files in the HTKK tax declaration software after exporting to XML. However, due to an unknown error, all periods are being converted to commas, causing difficulty in formatting numerical values. Mytour, please assist me in resolving this issue. I am using Windows 7.

Reader: Nguyen Phuong Khanh Linh

Response

Hello Khánh Linh, the issue of periods converting to commas when opening in HTKK from an Excel file is one of the common errors faced by users after installing HTKK to settle tax and declare taxes with the Ministry of Finance and related departments.

However, in reality, after installing HTKK on the computer, users have overlooked an important step in setting up and formatting data in HTKK, which is changing the National and Time Zone formats, as this is the decisive factor in changing periods to commas in Windows 7, 8, or Windows 10.

Linh, you can follow the instructions below from Mytour:

How to fix the issue of periods converting to commas when opening in HTKK from an Excel file?

Step 1: Access Control Panel on Windows 10 by pressing Start Menu > typing Control Panel and selecting from the search results. Alternatively, you can also access Control Panel directly from the desktop screen. Refer to some ways to access Control Panel shared by Mytour.

Step 2: In Control Panel, click on the Clock, Language, and Region section >Region or directly press the link Change date, time, or number formats for quick access.

Navigate to Region to set the region.

Or directly click on the linked text below named: Change date, time, or number formats

Step 3: Click on Additional settings to open extended settings for Region.

Step 4: In the Numbers tab >Digit grouping symbol, click the triangle symbol, switch from comma to period to fix the issue of periods converting to commas when opening in HTKK from an Excel file.

Press Apply > OK to finish. Reopen the XML file in HTKK to see the result after fixing the issue of periods converting to commas when opening in HTKK.

HTKK software supports professional tax declaration.

Regardless of the operating system you use, having professional XML file reading software alongside Excel is crucial when installing and using HTKK software. Apart from Excel, users often install iTaxViewer to view XML files in HTKK nowadays.

In addition, an equally important task to perform before starting tax declaration or sending tax declaration data to relevant departments is to back up data in HTKK to ensure all previously saved data is protected. Especially when backing up data in HTKK, you can avoid situations where software errors occur but there is no backed-up data file when it is needed to restore data in HTKK.

Similarly, in Excel, we have tricks to convert commas to periods by using some mathematical functions. For details on how to convert commas to periods in Excel, please follow along on Mytour.

Wishing you all success!

Frequently Asked Questions

What steps can I take to prevent periods from converting to commas in HTKK software?

To prevent periods from converting to commas in HTKK, access the Control Panel on Windows 10, navigate to 'Clock, Language, and Region,' and click on 'Region.' From there, select 'Additional settings' and under the 'Numbers' tab, change the digit grouping symbol from a comma to a period. Press 'Apply' and 'OK' to save your changes.

How can I back up my data in HTKK software to avoid data loss?

To back up your data in HTKK software, access the software's main menu and find the backup option. Regularly creating backups ensures that all previously saved data is protected, preventing loss in case of software errors. It is vital to perform this step before submitting any tax declaration data.

What alternative software can I use alongside Excel for reading XML files in HTKK?

Alongside Excel, users can install iTaxViewer, which is designed for viewing XML files in HTKK. Using dedicated XML file reading software can enhance the efficiency of tax declarations and ensure better compatibility with HTKK.

Why do periods convert to commas when using HTKK after exporting from Excel?

Periods convert to commas in HTKK due to regional settings in Windows. If your system is set to a region that uses commas as decimal separators, this will affect how numerical values are displayed in HTKK. Adjusting the settings in the Control Panel can resolve this issue.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]