Dollar formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2057062%22%20slang%3D%22en-US%22%3EDollar%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057062%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E2%20questions%20please%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20how%20do%20I%20change%20the%20format%20from%202.000%20to%202%2C000%3F%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E2.%20how%20do%20I%20change%20the%20accounting%20format%20to%20be%20usd%26nbsp%3Bautomatically%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThx%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2057062%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

2 questions please

 

1. how do I change the format from 2.000 to 2,000?

 

2. how do I change the accounting format to be usd automatically? 

 

Thx

 

2 Replies

@Orgo123 

1. Try the settings at File -> Options (all the way at the bottom under 'Account') -> Advanced -> then uncheck "Use system separators". It will then allow you to specify the character to use for thousands.

 

NReaden_0-1610553082685.png

 

2. You can change your region within the control panel to have the currency be dollars by default but it's simple enough to click the dropdown when choosing the currency format for the cell and choose dollars. If there are many cells you can use format painter to spread the currency format.

NReaden_1-1610554103551.png