cancel
Showing results for 
Search instead for 
Did you mean: 
Nissaya
Level 2

Change decimal separator

Hey) I want to change decimal separator in quickbooks. Now I have a comma separator between the integer and decimal parts. How can I replace it with a point?

Solved
Best answer February 25, 2020

Best Answers
Fiat Lux - ASIA
Level 15

Change decimal separator

check in your Windows setting

Control Panel > Clock, Language & Region > Region > Change date, time, number formats > Additional setting > Decimal symbol

View solution in original post

8 Comments 8
Fiat Lux - ASIA
Level 15

Change decimal separator

check in your Windows setting

Control Panel > Clock, Language & Region > Region > Change date, time, number formats > Additional setting > Decimal symbol

EthylicCedric
Level 1

Change decimal separator

I have the same question for Quickbooks Desktop Pro 2019 and Windows 11. I have done everything you mentioned, rebooted the system and even reinstalled the QB afterwards, but still nothing changes.
What else is there to do?

4Gal
Level 10

Change decimal separator

@EthylicCedric 

Have you tried what Fiat Lux shares?

Where do you live? You can ask them to schedule screen sharing to help if needed.

DebSheenD
QuickBooks Team

Change decimal separator

I can see the challenges with changing the decimal separator from comma to point in QuickBooks Desktop (QBDT),  @EthylicCedric. I'm here to help you resolve this matter.

 

We must enable this feature in the company preferences if you want to use the decimal point. By doing this, QuickBooks adds a decimal point to the item quantity automatically. You can take the next few steps to enable the decimal preference.

 

Here's how:

 

  1. Launch QuickBooks Desktop.
  2. Navigate to the Edit menu.
  3. Click on the Preferences and click the General section.
  4. Once you get into the My Preferences tab, you can place the checkmark for the Automatically Place Decimal Point tab.
  5. After this, click the OK button.

In preferences checkmark for the automatically place decimal point

 

Additionally, You might want to use some form templates so you can modify the details. QuickBooks contains the customization tools you need to make them so. Refer to this guide to complete the process: Customize Form Templates.

 

In case you need help with other customer tasks, click this link to go to our general topic with articles.

 

Let me know if you still have questions or concerns. I'm always here to help. Take care and have a wonderful day ahead.

EthylicCedric
Level 1

Change decimal separator

Hi,
I am in Hong Kong. I did everything that Fiat Lux suggested, but it didn't help. In the Windows 11 language settings I have 123,456,789.00 and QB writes 123 456 789,00. Because of this the export of reports to Excel fails.
Also, I am using a bilingual OS.
Thanks.

EthylicCedric
Level 1

Change decimal separator

No. It doesn't fix the problem

JuliaMikkaelaQ
QuickBooks Team

Change decimal separator

I know how important to change the decimal separator in QuickBooks desktop, @EthylicCedric. Let me route you to the support that can help you change it to your preferences.

 

Since none of the steps provided above didn't work and still fails to change the separator, I recommend contacting our customer support to help you further into this matter. They have the right tools to access your account and initiate a screen sharing to view your screen and look for the cause of this issue. You can follow the steps below to reach us:

 

  1. Open QuickBooks Desktop.
  2. Go to the Help menu, then select QuickBooks Desktop Help/Contact Us.
  3. Select Contact Us.
  4. Provide a brief description of your concerns, then select Continue.
  5. Sign in to your Intuit account, then select Continue, and click Continue with my account.
  6. Enter the single-use code that will be sent to your email, then select Continue.
  7. Select to chat with us or Have us call you.

 

Furthermore, I'll attach some helpful articles that you can visit if you want to manage your reports:

 

 

Let us know if you have other concerns about managing decimal separators or have any questions or inquiries about QuickBooks Desktop. The Community will be here and ready to lend you a hand.

4Gal
Level 10

Change decimal separator

@EthylicCedric 

Install the trial version of QB Desktop 2021 to make sure.

Need to get in touch?

Contact us