designing your own number formats, don't work

%3CLINGO-SUB%20id%3D%22lingo-sub-3006957%22%20slang%3D%22en-US%22%3Edesigning%20your%20own%20number%20formats%2C%20don't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3006957%22%20slang%3D%22en-US%22%3E%3CP%3Ein%20four%20blank%20cells%2C%20i%20entered%201200%20in%20the%20cell%20A1%2C%20i%20entered%20-8000%20in%20the%20second%20cell%20A2%2C%20i%20entered%200%20in%20the%20third%20cell%20A3%20and%20i%20entered%20the%20text%20Hello%20There!%20in%20the%20cell%20A4.%3C%2FP%3E%3CP%3EThen%20i%20selected%20all%20four%20cells%20as%20a%20range.%20I%20open%20the%20format%20cells%20dialog%20box%20by%20pressing%20ctrl%2B1%2C%20and%20i%20selected%20the%20Number%20tab%20and%20number%20in%20the%20category%20list.%20Whereupon%20i%20click%20the%3CSTRONG%3E%20%23%2C%23%230_)%3B%5BRed%5D(%23%2C%23%230)%3C%2FSTRONG%3E%20code%20in%20the%20custom%20Category%20Type%20list%20box%2C%20and%20then%20i%20edited%20as%20follows%3A%20%3CSTRONG%3E%5BBlue%5D%23%2C%23%230_)%3B%5BRed%5D(%23%2C%23%230)%3B%5BGreen%5D%3B%5BCyan%5D.%20%3C%2FSTRONG%3EAnd%20then%20i%20clicked%20OK.%20But%20it%20appaered%20me%20the%20following%20message%26nbsp%3B%20(see%20the%20screenshot).%20How%20can%20i%20fix%20this%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22c1.PNG%22%20style%3D%22width%3A%20550px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329530i42EBA18C346AE74F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22c1.PNG%22%20alt%3D%22c1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3006957%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%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3007028%22%20slang%3D%22en-US%22%3ERe%3A%20designing%20your%20own%20number%20formats%2C%20don't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3007028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1228382%22%20target%3D%22_blank%22%3E%40Bn_Rg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20do%20you%20see%20when%20you%20open%20the%20attached%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

in four blank cells, i entered 1200 in the cell A1, i entered -8000 in the second cell A2, i entered 0 in the third cell A3 and i entered the text Hello There! in the cell A4.

Then i selected all four cells as a range. I open the format cells dialog box by pressing ctrl+1, and i selected the Number tab and number in the category list. Whereupon i click the #,##0_);[Red](#,##0) code in the custom Category Type list box, and then i edited as follows: [Blue]#,##0_);[Red](#,##0);[Green];[Cyan]. And then i clicked OK. But it appaered me the following message  (see the screenshot). How can i fix this

c1.PNG

6 Replies

@Bn_Rg 

What do you see when you open the attached workbook?

i see 1,200 blue, i see (8000) in red, i see the 0 in green and i see the text Hello in cyan. But why did you ask this question? i don't understand, what you want to say me.

@Bn_Rg 

Just copy/paste format string which @Hans Vogelaar  suggested from his file. Typing manually perhaps you shall use semicolons instead of commas, depends on your regional settings.

Which setting should i change? I am reading the excel 2019 all-in-one foer dummies i copy the formula, i wrote above, as it's written in the book, namely, [Blue]#,##0_);[Red](#,##0);[Green];[Cyan].

@Bn_Rg 

Select the cell.

Press Ctrl+1.

If necessary, activate the Number tab.

Select the custom format string in the Type box, and copy it (Ctrl+C).

 

Do the same in your own workbook, but paste (Ctrl+V) instead of copy.

i fix the problem.