Custom cell format - conditional

%3CLINGO-SUB%20id%3D%22lingo-sub-1614801%22%20slang%3D%22en-US%22%3ECustom%20cell%20format%20-%20conditional%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1614801%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20formatting%20a%20negative%20number%20in%20Excel.%26nbsp%3BIn%20the%20format%20cells%20option%2C%20I%20am%20considering%20the%20customized%20one%3A%20_(*%20%23%20%23%230_)%3B_(*%20(%23%20%23%230)%3B_(*%20%22-%22_)%3B_(%40_)%20%E2%80%93%20this%20way%20I%20get%20a%20right%20formatting%20for%20the%20numbers%20with%20thousands%2C%20e.g.%20(10%20003).%20However%2C%20negative%20numbers%20with%203%20digits%20present%20an%20extra%20space%20between%20the%20first%20parenthesis%20and%20the%20number%20e.g.%20(%20103).%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20to%20custom%20the%20formula%2C%20in%20order%20to%20exclude%20the%20extra%20space%20before%20numbers%20with%20hundreds.%20I%20do%20not%20want%20to%20change%20the%20thousand%20separator%20option%20in%20Excel%20properties.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1614801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1614845%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20cell%20format%20-%20conditional%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1614845%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F772542%22%20target%3D%22_blank%22%3E%40carmemborim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E_(*%20%23%20%23%230_)%3B_(*%20(%23%23%230)%3B_(*%20%22-%22_)%3B_(%40_)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need help formatting a negative number in Excel. In the format cells option, I am considering the customized one: _(* # ##0_);_(* (# ##0);_(* "-"_);_(@_) – this way I get a right formatting for the numbers with thousands, e.g. (10 003). However, negative numbers with 3 digits present an extra space between the first parenthesis and the number e.g. ( 103). 

Please help me to custom the formula, in order to exclude the extra space before numbers with hundreds. I do not want to change the thousand separator option in Excel properties.

 

1 Reply
Highlighted

 

@carmemborim 

 

_(* # ##0_);_(* (###0);_(* "-"_);_(@_)